DSXchange

you can try g++ - O file.c to create its object file. I think
As Ray pointed out, try it out.

You can first load those 100 files to another folder, process them and then delete * from the folder.

I understand the part where you want to control the looping. Make it more clearer with examples. You can write a C function or maybe a BuildOp for more indepth control.

You can provide the tr function in the filter options of your sequential file stage. You dont need to redirect it to a new file.

Its just your SMTP server refusing to provide connection. Thats what I think.

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

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.

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.

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

If you want to delete only the records based on key field and insert new ones then you can choose update action "Replace existing rows completely" or do a simple update based on the key.

Well then there must be something going wrong during the ftp. Are you sure your doing an ASCII ftp both from mainframe to unix and then from unix to windows.

Then that means you are having line feeds within your data. Report this back to the Mainframe folks.

Rows do get processed one at a time, in other words, row by row. WHat exactly are you looking for. You question sounded vague to me.

Is it just some rows displaying this behaviour or all the rows?

Get the file ftp'd in ASCII mode. This will ensure that the correct line terminator will be present for each platform.