DSXchange

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.

You may want to look into the option of Loops in Job Sequence. If you choose that path, you can check the posts discussed on the same.

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.

You can write a stored procedure, yes, you can even write a C function. What exactly do you want to do?

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

May be there is a way to do in loops, but difficult to say, without getting a complete picture of what you are trying to do.
Can you elaborate please.

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

Depends upon your input. Keep in mind that the stored procedure will be called for each record. A C routine will be faster.

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 that value becomes my 11th digit.

A check digit, in other words. Best to do that in C, I would think...

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

What compiler option do you have. If you have aCC, then you can use acc +Z yourfunction.c
That will create the object file. Create a px routine from the manager, give it a name, external function name will be the name of your c function. Give the path of the object file.

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

Depending upon your compiler, you will provide the options. It will be present in APT_COMPILEROPT environment variable.

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

-O -fPIC -Wno-deprecated -c

Rather than asking "will it work?" why not try it?