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%'