DSXchange

You installed what? Oracle aps? Do you mean oracle API stage?

You can make sure of that via link ordering. But that will only happen for a 'per row' basis. If you want all inserts first and then all updates or vice versa for that matter, do it in seperate jobs.

Using one client, your desktop, can you communicate to both versions??? If you can then I bet you can do the same within datastage as well.

You can do this in a script then I guess. Utilize grep, awk, sed. Lookup their examples online.

Your errors are due to the LF or @FM as i suggested before. If you can run the above without compilation errors, you should be able to run Field(). Also, dont do this at the triggers. Do it inside job activity while providing expression for your job parameter.

I read this in a magazine a while back. Or maybe it was one of those fwd emails that I got. Anywho, there are quite a few good ones out there. Good one gateleys.

Help yourself.
PL/SQL will run on database and C function will run on your datastage server. Why are the folks at your end scared to death from C? Ask them if you can do it in a unix script?

Welcome Aboard,
Dont you have to give the fully qualified path of myfile.ds ???

Copy paste the entire message from the log. Also there may be few warning messages, post them as well. Reset the job and see if you have any more warning/error messages "From previous run..". Specify a reject link from sequential file stage to a peek stage. It will tell you what records are the culp...

Many stages support reject links. What is your source? What is the error message that you get in the log?

Ray's advise to run on dual was for testing purposes. You will reference the table which has the column 'XYZ_DESCRIPTION'. Use this function inside the database stage. Use generated sql. Put the function in the derivation of 'XYZ_DESCRIPTION' in the column tab. Examine the sql to be like how you wan...

sqlcode has the code from the database for the reason of rejection. You can limit the warnings by setting the number of warnings during run time. Similar to 'dsjob -warn' option through command line.

Can you wrap that command in a .cmd or .bat file and execute that bat file from DSExecute()?

Password file I did not get that...