Home > IT Answers > AS/400 > Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB
Minidach
15 pts.
 Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB
AS/400, Embedded SQL, Microsoft SQL Server
I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done this?

Software/Hardware used:
RPG - AS/400
ASKED: September 23, 2009  3:35 PM
UPDATED: September 24, 2009  4:18 PM
RELATED QUESTIONS
Answer Wiki:
Minidach: Using JDBC, you can directly access an MS-SQL database. If you visit the SYstem i Network website and forums, you will find several articles, down-loadable code, etc. You MAY be able to access an MS-SQL database using IBM i DB2 SQL, but I have not personally done that. HTH Jon Juracich.
Last Wiki Answer Submitted:  September 24, 2009  2:08 pm  by  JJuracich   15 pts.
All Answer Wiki Contributors:  JJuracich   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

Thank you Jon! I’ll look out there and see what I can find.

Minidach
 15 pts.