cannot upload through ODBC

fahad · Post by **fahad** » Wed Jul 06, 2005 10:13 am

Hi all,
i am trying to upload text file to as400/db2 table through ODBC stage. it doesn't upload the data and give this warning log:
"***BCIPut call to SQLExecute failed ****
[DataStage][SQL Client][ODBC][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - Table2 in FahadLib not valid for operation."

what do you think is the problem?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Jul 06, 2005 11:40 am

That does not appear to be a DataStage problem. You need show this to your DBA and ask for info

ml · Post by ml » Thu Aug 25, 2005 8:45 am

Hi fahad,

I think that you need to start journaling for those "Library.files" on as400 in order to allow DataStage(odbc) to insert/update/delete on those tables.

these are the step on AS400:

1 Create a journal receiver (CRTJRNRCV).
2 Create a journal (CRTJRN) specifying the journal receiver created in step one for the JRNRCV parameter.
3 Start journaling on the file (STRJRNPF).

regards,

mat

Titto · Post by **Titto** » Thu Aug 25, 2005 2:06 pm

add WITH NONE; and the end of the SQL statement