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.