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

My method probably is the best. but...

I meant... NOT THE BEST.


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
3776 South High Street, Columbus, OH 43207
Phone: 614/492-7419 Fax: 614/409-2017
Visit us on the web! www.bobevans.com

(Embedded image moved to file: pic28558.gif)




rpg400-l-bounces@xxxxxxxxxxxx wrote on 03/17/2008 04:15:13 PM:

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.

--
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.