All is well, and it works like a charm... I was able to hit the SQL Server, and pull my data into my rpg real time...
Scott, thank you again for you awesome code.
Tim
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Hatzenbeler, Tim
Sent: Monday, March 17, 2008 2:22 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: Retrieveing SQL Server data, from RPG using jdbc.
To everyone who replied, Thank You!
I have Scott's code compiled, but I'm having a class not found problem...
But hopefully I'll have that figured out soon.
Thanks again,
tim
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Monday, March 17, 2008 1:41 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Retrieveing SQL Server data, from RPG using jdbc.
<snip>
I have a need to access a SQL server from an RPG program. And I would
like to use the JAVA jdbc for SQL server to do this.
And then iter through my result set and write it to an as/400 PF.
Is there a link to some code, or has anybody done this?
<snip>
I use a modified version of Scott's JDBC service program (Conform to our
names standards) on a daily basis to read SQL Server data and write
physical files. Also, check a value in SQL Server and update AS/400
tables.
Just added the support for calling stored procedures. Works great.
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
------------------------------------------------------------------------------
This e-mail message, including any attachments, is for the
sole use of the intended recipient(s) and may contain
confidential or privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If
you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.
==============================================================================
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
------------------------------------------------------------------------------
This e-mail message, including any attachments, is for the
sole use of the intended recipient(s) and may contain
confidential or privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If
you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.
==============================================================================
------------------------------------------------------------------------------
This e-mail message, including any attachments, is for the
sole use of the intended recipient(s) and may contain
confidential or privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If
you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.
==============================================================================
midrange.com
