Hi All,
Iam new to datastage... Iam trying insert the data in the table... but iam not able to insert the data .. do i need to write the insert statement for the values which iam going to insert??
Can you please guide me how to insert data by using the insert statement.
Inserting the data into db2 using db2 connector stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 89
- Joined: Sat Jul 24, 2010 11:33 pm
Re: Inserting the data into db2 using db2 connector stage
You will have to give us more details on what you are trying to do in your datastage job and what is not working, what stages you are using and the database you are connecting to. What are the options you are using within the database stage? Upsert or User defined updated sql etc etc
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
-
- Participant
- Posts: 89
- Joined: Sat Jul 24, 2010 11:33 pm
Re: Inserting the data into db2 using db2 connector stage
Hi Kris,kris007 wrote:You will have to give us more details on what you are trying to do in your datastage job and what is not working, what stages you are using and the database you are connecting to. What are the options you are using within the database stage? Upsert or User defined updated sql etc etc
Iam inserting the data into the db2 using DB2 connector stage.... i gave db name,username,password ,table name and mentioned to generate SQL to yes. Insert option. Table is empty with the column names. Iam inserting the data in the empty table but i keep getting the error unable to insert the values ....
-
- Participant
- Posts: 89
- Joined: Sat Jul 24, 2010 11:33 pm
DB2_Connector_226,1: [IIS-CONN-DB2-000004] DB2 function SQLExecute failed: SQLSTATE = 23502: Native Error Code = -407: Msg = [IBM][CLI Driver][DB2/AIX64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=2, TABLEID=270, COLNO=2" is not allowed. SQLSTATE=23502 (CC_DB2DBStatement::executeInsert, file CC_DB2DBStatement.cpp, line 563)kris007 wrote:Can you post the complete error message from the log including the SQL codes. Looks like a permissions issue to me. If you can, please post the generated SQL as well.