Error Insert into dB2 using ODBC Connector Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
GSIDSXGrp
Premium Member
Premium Member
Posts: 19
Joined: Tue Jul 31, 2007 2:25 pm

Error Insert into dB2 using ODBC Connector Stage

Post by GSIDSXGrp »

Hi,
I am using ODBC Connector stage to insert records into dB2 files. I am getting following error.

"ODBC_Connector_7,0: [IIS-CONN-ODBC-000016] Execute failed on statement INSERT INTO schhabra.tststr(STRNUM,STRNAM) VALUES(?,?)"

This error looks like I am trying to insert Null (?) value to my database, but to make sure no null value is there I have inserted a Peek stage also before ODBC Connector Stage. And my datastage director is showing me the values in Peek stage.

In ODBC Connector I have selected Auto create insert SQL. I have tried writting my own insert statement, but of no use. I got the same error.
Can any one advice me what am in missing?

Regards,
-Sumit Chhabra
Post Reply