result value, SQLSTATE value, message text, or scratchpad wh

harryhome · Post by **harryhome** » Mon Apr 30, 2007 12:12 am

hi,

I am getting following error in my job . Its a simple job of extracting data from database and loading it into the sequential file.

SrcODDC_PPOPRCH..Src_PPOPRCH: [IBM][CLI Driver][DB2] SQL0450N Routine "SQLTABLES" (specific name "014") has generated a result value, SQLSTATE value, message text, or scratchpad which is too long. SQLSTATE=39501

plz help.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 30, 2007 12:42 am

Have your DB2 DBA enable tracing so as to capture the value that is generating the error.

Do you really have a table called "014"? Do you have a job design that has "014" as the table name in a stage?

harryhome · Post by **harryhome** » Mon Apr 30, 2007 4:45 am

Please tell how to enable the tracing so as to capture the value that is generating the error

ray.wurlod · Post by **ray.wurlod** » Mon Apr 30, 2007 5:00 am

It is a tool and skill that a DBA would have, not necessarily that a DataStage developer would have.