What's the best to access MS Sequel Server data via ILE-RPG?

Posted on 2016-10-26
Medium Priority
Last Modified: 2016-11-04
We have a local MS Sequel Server on the network. I need to access Sequel database info using our IBM i v7r1 via ILE-RPG program.
Any Takers? Thanks!
Question by:Phillip Knox
  • 2
LVL 36

Accepted Solution

Gary Patterson earned 2000 total points
ID: 41860977
IBM's solution ($$) is DRDA via the the IBM InfoSphere Federation Server (or whatever they call it today).


Also other 3rd party products that can do the same.

Easiest way to DIY without spending money on software is JDBC.  Scott Klement has some open source code that makes it faster and easier to integrate.  I've worked with his code library in the past and though it isn't quite production-quality code, it really is a big time-saver over creating it yourself.


Author Comment

by:Phillip Knox
ID: 41867306
Thanks Gary
LVL 36

Expert Comment

by:Gary Patterson
ID: 41867324
Happy to help.

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question