Re: Retrieveing SQL Server data, from RPG using jdbc.

My method probably is the best. but...

We have a generic Java program that accepts a SQL statement and it will run
it against the server being requested. The Java App would then create the
results in a vector. When the vector has been built, control is sent back
to the RPG program and we call another java function in the app to get the
records from the vector. The results are delimited by a "|" and we have a
custom procedure to spilt on the "|" delimiter.


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.



rpg400-l-bounces@xxxxxxxxxxxx wrote on 03/17/2008 03:50:02 PM:

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?

Thank You,
Tim

------------------------------------------------------------------------------

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.