Data truncation is happening

deepa_shenoy · Post by **deepa_shenoy** » Thu May 19, 2011 10:48 pm

Hi,

I am unable to view data from the DB2 source stage. It is throwing the below error.

DB2_COLR: The size specified for column 'COLR_N' (16) is less than that of the source table column (50);data truncation may result.
DB2_COLR: The size specified for column 'CRTE_TS' (16) is less than that of the source table column (26);data truncation may result.
DB2_COLR: SQLExecDirect: DB2 error info message '[IBM][CLI Driver] CLI0113E SQLSTATE 22007: An invalid datetime format was detected; that is, an invalid string representation or value was specified. SQLSTATE=22007'.
DSTAGE-DB2CLI-0026`:`SQLFetch: Error retrieving results from server.

The data type in the source, and the metadata given in the DB2 stage are exactly the same. What could be the issue?

premupdate · Post by **premupdate** » Fri May 20, 2011 12:51 am

Hi,

Enable the environmental variable OSH_PRINT_SCHEMA and compare the metadata.

deepa_shenoy · Post by **deepa_shenoy** » Fri May 20, 2011 5:14 am

No that did not help.

Although, if you arrange the columns in the Custom SQL same as the order in the Metadata, that works!!

A silly solution, but a solution nonetheless

chulett · Post by **chulett** » Fri May 20, 2011 6:21 am

Silly solution? More like an absolute requirement.

deepa_shenoy · Post by **deepa_shenoy** » Fri May 20, 2011 6:34 am

Is it? Oh my mistake then. I did not know that.

In DS 8 there was no such requirement. Still getting used to DS 8.5.

chulett · Post by **chulett** » Fri May 20, 2011 6:41 am

Always been a requirement, as far as I recall. [shrug]