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
DB2 Load error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 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.
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.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
Working gr8
Thanks dude
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.
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
RaviM wrote:Working gr8
Thanks dudekwwilliams 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?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: