DSXchange

Is the deletion done for the table where you need to load the informations into?
Are you sure the Strored procedure executed will be completed before the job starts.
Try to comment some of the suspicious steps in the shell and execute the jobs to isolate the culprit.

Do you mean 'Multiple rows returnd from link'?
If so, this is enable only for reference link.

What is the value for docnum. By any chance is docnum is equal to 1?
Are you doing any type conversion after the transformer?
What is the datatype of the field in the transformer which holds the value?

Since the column is specified as Nullable, Datastage expectes null for the column should be handled prior to load. Either you can use transformer/modify stage to handle explicitly or as mention Nullable field value to specify implict null handling.

Transformer_53: Failed to load the library "V0S53_ParallelRoutineTest_Transformer_53.so"; either the directory containing the library file is not on the library search path, or the library was compiled on a system this should be give you the information. Pls make sure the path where the object code...

LANG_ID Char(2) should be having some additional character like space.

So what is the Shell scripts does?
BTW have you checked with dataset instead of database stage?

Are the object codes for the routines are inthe same path still?

Atlest to create a dataset you need to read through sequential stage.
The 'Field001' which as the value of '0 6 / 0 4 / 2 0 0 6' is not the internal date formate for datastage. Hence reade it as char or varchar and later convert it into date field.

What do you mean by link name dropdown list? Is it 'Input name' in the Input tab. Are you sure you have connected properly the linkt to the lookup stage?

Interesting!!
I could only see some internal warning messages stored in that directory. I am not sure how that help to resolve.

Depends on you desing and requirement the stages can be decided.
Datastage doesnt have any unconnected lookup in data stage like Informatica have.
But you can relialise similar performance by populating the hash file and it can be lookep up at multiple places.

You can find a link to it in Kum Duke's signature.

http://www.Duke-Consulting.com/DataStage_Tips.htm

It checks for incompatable data type. Metadata mismatch will also come under wrong datatype at times for all the columns in the rows.

Hi Rax,
Edit your both post and mention the correct version and Job type you use along with the OS you use.