AS/400 loading problem?
Posted: Mon Aug 20, 2007 12:18 am
When i tried to load the data in AS/400 by using ODBC stage,following error is coming
EP_lodins_future_planned_ordersC..MapToPopf0107DbTgt.Popf0107DbTgt: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO RAC56041.POPF0107(OPVENDOR, OPSUBVEN, FILLER1, OPLOC, FILLER2, OPORDERPER, OPVENTYPE, OPITEM, OPPRIMKEY, OPPRIORITY, OPORDERQTY, OPFIXEDMIN, OPCOMPMIN, OPMULTLOT, OPWEIGHT, OPCUBE, OPDOLLARS, OPDECIMAL, OPCENTS, OPUOMEQV, OPWGHTEXT, OPCUBEEXT, OPDOLLARSE, OPDECIMALE, OPCENTSEXT, OPUOMEQVE, OPREQDATE, OPCARRETN, OPLINEFEED) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
SQLSTATE=S1000, DBMS.CODE=-7008
[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]POPF0107 in RAC56041 not valid for operation.
Thanks
Malli
EP_lodins_future_planned_ordersC..MapToPopf0107DbTgt.Popf0107DbTgt: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO RAC56041.POPF0107(OPVENDOR, OPSUBVEN, FILLER1, OPLOC, FILLER2, OPORDERPER, OPVENTYPE, OPITEM, OPPRIMKEY, OPPRIORITY, OPORDERQTY, OPFIXEDMIN, OPCOMPMIN, OPMULTLOT, OPWEIGHT, OPCUBE, OPDOLLARS, OPDECIMAL, OPCENTS, OPUOMEQV, OPWGHTEXT, OPCUBEEXT, OPDOLLARSE, OPDECIMALE, OPCENTSEXT, OPUOMEQVE, OPREQDATE, OPCARRETN, OPLINEFEED) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
SQLSTATE=S1000, DBMS.CODE=-7008
[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]POPF0107 in RAC56041 not valid for operation.
Thanks
Malli