Access a MS Sql Table from the AS/400

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Bruce

<I have search the archives but could not find an example of hot to setup on
the AS/400 to access a table on the Micro$oft SQL Server. We are running a
270 with V5R1. I need to be able to do an Insert, Delete and Update to the
table on the Micro$oft SQL Server from the AS/400. I want to read an DB2/400
File and then do the Insert, Delete or Update to the Micro$oft SQL Server.

I don't know if there is a JDBC driver for SQL that would run on the AS/400,
but that would be the only AS/400 (Client) => MS SQL (Server) connection
that I know about.  What I have done on several occasions is to install CA
on the NT machine and start the remote command server.  Then from the AS/400
do a RUNRMTCMD to execute either OSQL to execute a .SQL file, or DTS_RUN to
execute a DTS procedure.  In either of these cases, the AS/400 job will wait
until the SQL procedure, using ODBC, does the operations from the SQL side.
The output is then placed in an OUTQ which you can extract and look at to
see if it ran successfully or not.

Another scenario would be to write a program using VB/C/Vbscript/Java/etc
using the CA/JAVA Programmer's Toolkit to monitor a Data Queue on the 400.
Messages placed in the Data Queue would cause the program on the NT side to
run and status info could be passed back in the queue.  In either case, the
SQL Server side would be the client using ODBC/JDBC to access DB2/400.

HTH,

Tim

Tim Sullivan
Access Paths, Inc
Londonderry, NH 03053

--