Home > IT Answers > Development > AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database.
Theraven
35 pts.
 AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database.
API, AS/400, COBOL, iSeries, SQL Server, V5R4
I have a AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database. Is there a API or some method for doing this. Help.

Software/Hardware used:
OSV5R4 AS400
ASKED: August 7, 2010  1:27 AM
UPDATED: August 9, 2010  1:06 PM
RELATED QUESTIONS
Answer Wiki:
Access to SQL Server from a different platform is done the same way almost all databases are accessed cross-platform. Download the driver from the vendor for the platform you're running on. The only driver that I'm aware of that Microsoft currently makes available that will run on your AS/400 is the <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707&displaylang=en">Microsoft SQL Server JDBC Driver 3.0</a>. It works because it is a JDBC Type 4 driver. Your COBOL will make calls to a Java program that you will provide. The Java program can then use JDBC to access your SQL Server database. Tom
Last Wiki Answer Submitted:  August 7, 2010  4:03 am  by  TomLiotta   108,310 pts.
All Answer Wiki Contributors:  TomLiotta   108,310 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _