Error extracting data from a AS/400 system
Posted: Wed Jun 29, 2005 3:15 pm
Hi All,
I'm trying to extract data from a AS/400 system. The table name is INVDPT.
In my job, I have a ODBC stage, a transformer and a flat-file target.
In the ODBC stage, I selected the generated query option in the "General" tab of the "Outputs" page. I also added the INVDPT table. I loaded the columns of the table from the imported table definition in the "Columns" tab.
But when I try to "view data". I get this error.
So, I decided to use "User-defined query" instead. And when I type the query as
I'm able to view data this time. Why is this happening? Any ideas and suggestions or answers would be appreciated. How would I be able to view the data without the user-defined query? Thanks,
Whale.
I'm trying to extract data from a AS/400 system. The table name is INVDPT.
In my job, I have a ODBC stage, a transformer and a flat-file target.
In the ODBC stage, I selected the generated query option in the "General" tab of the "Outputs" page. I also added the INVDPT table. I loaded the columns of the table from the imported table definition in the "Columns" tab.
But when I try to "view data". I get this error.
Code: Select all
Test2..ODBC_0.DSLink3: DSD.BCIOpenR call to SQLExecDirect failed.
Statement was:SELECT COMPVIEW/DEV2LIB.INVDPT.IDEPT, COMPVIEW/DEV2LIB.INVDPT.ISDEPT, COMPVIEW/DEV2LIB.INVDPT.ICLAS, COMPVIEW/DEV2LIB.INVDPT.ISCLAS, COMPVIEW/DEV2LIB.INVDPT.DPTNAM, COMPVIEW/DEV2LIB.INVDPT.DPTSHT FROM COMPVIEW/DEV2LIB.INVDPT
SQLSTATE=S1000, DBMS.CODE=-5016
[DataStage][SQL Client][ODBC][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL5016 - Qualified object name INVDPT not valid.
Code: Select all
SELECT * FROM DEV2LIB/INVDPT
Whale.