DSXchange

If the issue exist still do the following

The property APT_AUTO_TRANSPORT_BLOCK_SIZE must be commented out in the zprofile of the unix admin id who installed the datastage.

DataStage by default puts entries into the profile while installing.

I have 3 jobs. In my first job i do some calculation. If the result is say 1 then i run the second job with that value else i run the third job.

Can any one let me know how to pass the the value from a transformer stage to the environmental variable so that i can use it in the next job.

i got the following options in APT_COMPILEROPT and my compiler is g++.

-O -fPIC -Wno-deprecated -c

can you let me know where can i check my compiler options.

Can you please let me know how to compile and link it the job.

i need to implement the following logic in loop i get a 10 digit value in string format a the input. i should take each digit places from 1 to 10 and divide them with 2. if my remainder is 0 then i need to store it in a variable and keep adding it up till my loop is finished. at the end of my loop t...

I want to know will there a hit on performance if i am using a store procedure.

But i need to perform the loop operation for each record.
if i am right,in job sequence i can only run the entire job in loops.

i need to perform a for loop logic for each of my input record. can i write this logic in a procedure and call it.

please let me know what is the best option.

unfortunately i am not a premium member and i could not read the entire message.

if its possible can you let me know how i can do it.

hi

i need to call a external data service via http by passing some parameters and get some return values. can any one let me know if it is possible.

Thanks,
Karthik.

the column is not null in datastage job also.

this column is the primary key in my table, so it cannot be null. and i am doing a simple load to the file.

hi i am loading the data from a table into a sequential file and i am getting the following error. When checking operator: When binding output interface field "TYPE_ID" to field "TYPE_ID": Converting a nullable source to a non-nullable result; But the column is not null in source...