RPG and Windows SQL Server

[jsentigar]

Can anyone assist me in how to access through an RPG program, database records that reside on an Windows SQL server. I need only read access to these records and cannot seem to find an easy way.

Thanks

 

[flapeyre]

You can do it through a sockets program, but the easy way is to FTP the file over to the AS/400, and process that with an RPG program. The destination file can either be a flat file or a DDS-defined file.

If the file on the server has several different formats (like a bank ACH file), I have logicals over the flat file which define the fields and select only that format. If all you need to do is read the file, then that should work.


"When once you have tasted flight, you will forever walk the Earth with your eyes turned skyward, for here you have been, and there you will always long to return."

--Leonardo da Vinci

 

[sritzel]

There is a company called RJS Software Systems that makes a product that allows you to do this:

http://www.rjssoftware.com/index.asp?pg=rjsrpg2sql.htm