DB2 Load error

RaviM · Post by **RaviM** » Fri Mar 10, 2006 11:27 am

Hi All,

I am gettinng below error while loading into AS400 through ODBC stage

ERROR :
[DataStage][SQL Client][ODBC][IBM][CLI Driver][AS] SQL7008N REXX variable "SBMSCHIR " contains inconsistent data. SQLSTATE=55019

Has anyone any ideas...........
The OS Im using is Windows 2000

Thanks

ray.wurlod · Post by **ray.wurlod** » Fri Mar 10, 2006 11:32 am

The error message indicates that the row is getting out of DataStage successfully, but something about it is being rejected by DB2. Chat with your DBA as to the meaning and remedial action possible when error code SQL7008N occurs. Track down (or search the Web) for information about the generic ODBC error 55019.

kwwilliams · Post by **kwwilliams** » Fri Mar 10, 2006 1:43 pm

After your sql put the words: "WITH NONE". So if your sql look like:

Insert into table1 (col1,col2) values(?,?)

Change it to:

Insert into table1 (col1,col2) values(?,?) with none

I believe that your target table is a non-journaled table, and you need to either set the nonjournal property of your connection to true or use with none after your statement.

RaviM · Post by **RaviM** » Fri Mar 10, 2006 2:47 pm

Working gr8
Thanks dude

kwwilliams wrote:After your sql put the words: "WITH NONE". So if your sql look like:

Insert into table1 (col1,col2) values(?,?)

Change it to:

Insert into table1 (col1,col2) values(?,?) with none

I believe that your target table is a non-journaled table, and you need to either set the nonjournal property of your connection to true or use with none after your statement.

kwwilliams · Post by **kwwilliams** » Fri Mar 10, 2006 3:18 pm

RaviM wrote:Working gr8
Thanks dude

Glad to hear it!

ray.wurlod · Post by **ray.wurlod** » Fri Mar 10, 2006 4:05 pm

That's obviously a DB2 thing. In Informix you might have created the table with no logging. Doubtless other databases have similar functionality.

deva · Post by **deva** » Thu May 27, 2010 11:16 am

RaviM wrote:Working gr8
Thanks dude
kwwilliams wrote:After your sql put the words: "WITH NONE". So if your sql look like:

Insert into table1 (col1,col2) values(?,?)

Change it to:

Insert into table1 (col1,col2) values(?,?) with none

I believe that your target table is a non-journaled table, and you need to either set the nonjournal property of your connection to true or use with none after your statement.

What if it is a journaled table? what kind of properties we need to set?

We are using db2 connector. If possible can you please send the odbc entry?

ray.wurlod · Post by **ray.wurlod** » Thu May 27, 2010 11:20 am

DB2 Connector does not use ODBC protocol.