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
AS/400 loading problem?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 81
- Joined: Thu Nov 30, 2006 7:46 am
- Location: india
AS/400 loading problem?
MALLI
Re: AS/400 loading problem?
I think you should use DB2 stage
Re: AS/400 loading problem?
The file on the AS400 you are trying to load to must be journaled on the AS400.
Re: AS/400 loading problem?
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
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
Those who throw objects at crocodiles should be asked to retreive 'em.
-
- Charter Member
- Posts: 166
- Joined: Wed Mar 16, 2005 6:52 am
- Location: Mumbai, India
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.
I'm not a DB2 expert but i think this disables commit control for the SQL.
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>