DSXchange

You probably need to incorporate DS_CONTAINERS in that query somewhere. Server shared containers are probably referenced by their DSRID. (I have not checked this.)

Still not there. Am I being impatient, perhaps?

My bad. You can only use Null Field Value for numeric data types.

"Prefix length" refers to the length prefix on a VarChar data type. "Link length" I am not 100% certain about, but suspect it would relate to a VarChar field being used as a link field for a tagged subrecord.

Is there a fixed number or an arbitrary number of delimited fields? Within DataStage some combination of Index(), Field() and Len() functions and substring operators could do it, while you could almost certainly script it with a combination of grep and awk.

It's complaining (initially) about this line: "001002138",,,,,,,,,,,,,,,,,, PC is the second column, but has nothing (or "") in its field. PC is Integer data type, and "" is not a valid integer. You have to specify a valid default value to use if "" is encount...

Can we please see the first six lines of your file?

If not, please verify that PC has a value in the sixth line (remember that they are numbered from zero).

First off, what Write Mode are you using?

Have you drawn a reject link from the Oracle Enterprise stage? Direct this, through any other stage types you feel to be appropriate, to a Sequential File stage to capture the rejects.

It depends on your numeric precision setting, but it's at least 14 digits.

Are all the rows making it into the sequential file?

If not, is there a constraint expression in the Transformer stage?

REQUIRE.INDEX is the "hint clause" you need. If an index can not be used your query containing this keyword will fail. Index usage is cost-based - if the query will return more than about 30% of the rows in the table, then the index is not used because, on balance of probabilities, every p...

That was an incorrect assertion. Char(0) in DataStage represents the ASCII NUL character, just like in Oracle. In C this character is used as a string terminator character. The internal, or "out of band", representation of NULL (unknown value) in DataStage is Char(128) except on Windows pl...

The second person personal pronoun in English is spelled "you", not "u". Please strive for a professional standard of written English on DSXchange, because even good English is difficult enough for those whose first language is not English, and because DSXchange is no an SMS-enab...

There is NO OTHER WAY.

DataStage was designed to be driven by metadata, not the other way around.

No.

Have them justify their assertion with evidence and do share it with us.

Ask your DB2 DBA to help, or refer to the DB2 errors and messages manual. This error is being generated by DB2.