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?
cannot upload through ODBC
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
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
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