DSXchange

hi

how can i store the previous domain or server details while logging into datastage v8.1

In some blog i got an info that i should give write/modify access to C:\IBM\InformationServer\ASBNode\conf folder. if this is correct, then how can i give access to this folder.

sorry for insufficient information provided.

i was pointing to parallel routine, not after/before routines.
i want to invoke a generic parallel routine from other parallel routines.

hi

i want to invoke a routine from another datastage routine.
Basically i have a generic routine which has to be called many a times from another routines.
please let me know how to call this.

with this the performance will be atleast improved. Your proof? How are you moving the records from Oracle to the text file(s)? Why not just effect the lookup direc ... Ray, i mean to say i am using a normal unix file instead of an oracle table. so instead of creating insert statements for the give...

Now due to performance issue with the oracle connectivity for each and every record, i am planning to keep all my lookup table contents into normal unix file seperated by comma. with this the performance will be atleast improved. On whole now my requirement is to : 1. call a c routine in datastage t...

how about an Exec command squncer stage to call the C program, which inturn call the your scrip tin it. thats a good idea to call routine but i want to call routine from transformer itself. how about an Exec command squncer stage to call the C program, which inturn call the your scrip tin it. yes t...

hi i want to invoke a unix script in a C program or datastage routine and also return some value from the script to the C program to use that value further. Basically i am doing a Lookup operation in this unix script and returning the looked up data from a oracle database table.. please help me invo...

hi How to call another parallel routine from main routine? What are the library functions which should be used in the main routine? I have to pass a pointer parameter from main routine to another routine. and take back the values means returned value in a pointer which is in main routine. Please hel...

Hi ray, i think you didn't read my whole requirement. I accept the code which i have written is just a basic functionality of lookup, but it has a dependency because the input for this is given based on some validity condition from another routine and the output from this routine will be used to tak...

If you are going to use file pointers with open and close each time, think about running 1 million (or billion) rows through it. So please suggest me something which can overcome this performance issue. Also what happens if you call the function in parallel ? ... Sorry i didn't understand this!! pl...

hey thanks,

As you said it was my mistake, i didn't use the compiler options.
Now its working fine.

hi all, i am almost done with my coding but struck at some big error. let me explain clearly. the below code is working fine with a main function but its not working if i want to change the function name to create a routine. it gives this error: ld: 0711 - 317 ERROR: undefined symbol:.main ld: 0711 ...

yes you are exactly correct, its not a actual lookup but just existence check. ok now i have kept all my requirements into this blog: Routine name:ORIG_BANK_BIC 1) Initialize the varaibles as given to "" 2)If _FLAG[IN_COV] == 1 then --- this variable is set in jbTXN8952WireTxnTfm1 i.e. svF...

oh i forgot to tell that this small c program is called inside another routine many times. and the input and output values of this lookup c program is supplied by the external main function runtime based on other values. i can handle the main function but problem is with lookup with unix file. So pl...

hi all, i have a requirement to lookup a file through placed on unix from C program. Let me explain the example below: Lookup_codes.txt contains: IN UK HK US EN like this i have 250 country codes available in individual lines. My C program Lookup_county.cpp should contain: 1 or 2 parameters like 2 d...