Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB
Home > IT Answers > AS/400 > Is it possible using Embedded SQL or somethin...
Minidach
15 pts.
0
Q:
Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB
AS/400, Microsoft SQL Server, Embedded SQL
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: Sep 23 2009  3:35 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
JJuracich
15 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Sep 24 2009  2:08 PM GMT by JJuracich   15 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Minidach   15 pts.  |   Sep 24 2009  4:18PM GMT

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

 
0