AS/400 loading problem?

[mallikharjuna]

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

[reypotxo]

I think you should use DB2 stage

[lindsm01]

The file on the AS400 you are trying to load to must be journaled on the AS400.

[ds_is_fun]

The most common type of dB on AS400 is DB2.
You will need to first configure DB2 using DB2 wire protocol.
Then use DB2 ODBC stage to connect to the dB on AS400.
To configure DB2 pl. follow the link from a previous post -
http://dsxchange.com/viewtopic.php?t=11 ... 8451d1c3f4

[ameyvaidya]

Journaling needs to be enabled or the other option is use the "With NC" clause in the SQL query.

I'm not a DB2 expert but i think this disables commit control for the SQL.