October 15, 2010 at 2:05 pm
Hello,
We have a requirement to transfer data from SQL tables (may be derived data) to AS400. With this SQL server also need to get intimation from AS400 as it has processed all records and updated in their system. If any issue is there AS400 need to be sent it back for that particular errornous row.
This interface will be running in real time as a scheduled job hence SQL server need this information so that when next time job will run it should not send data which is already being sent earlier and proceesed successfully by AS400. Basically we need flagging.
Has anyone done a similar kind of approach earlier?
Can we update AS400 data (I am not sure of AS400 structure) from SQL?
Please assist
Tahnk You
August 6, 2014 at 12:50 am
hi
i am also facing same problem . if you know something about this.please let me know how to solve this problem. i am some error like this:
[OLE DB Destination [26]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Could not create an acceptable cursor.".
January 28, 2015 at 12:14 pm
Hi guys,
I can tell you following:
1. if you're connecting to AS400 from the desktop using an iSeries client, you'll need that client on the SQL server.
2. Connect to AS400 using LINKED SERVER with the correct AS400 credentials
3. Make sure the the user has C/INSERT/WRITE permissions
4. Use OPENQUERY to CRUD
select ordno, orqty, fitem, fdesc
from openquery (AS400, 'select ordno, orqty, fitem, fdesc
from amflibq.MOHMST')
where ordno LIKE 'M3384%'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply