Re: ProgramCall and ProgramParameter classes

[Eric Merritt <cyberlync@xxxxxxxxx>]

Bruce,

 The sun JDBC trail provides a little information at
http://java.sun.com/docs/books/tutorial/jdbc/basics/sql.html

and a little more here

http://developer.java.sun.com/developer/onlineTraining/Database/JDBC20Intro/JDBC20.html#JDBC2013

as for setting up an RPG program as a stored procedure
your will probably have to check one of the redbooks
for that.


--- Bruce Jin <brucej@mrc-productivity.com> wrote:
> Eric could you provide a few resources (or links) on
> using JDBC stored
> procedures call?
> 
> Thanks.
> Bruce
> 
> -----Original Message-----
> From: Eric Merritt <cyberlync@yahoo.com>
> To: JAVA400-L@midrange.com <JAVA400-L@midrange.com>
> Date: Friday, March 30, 2001 11:11 AM
> Subject: Re: ProgramCall and ProgramParameter
> classes
> 
> 
> >Robert,
> >
> >  If I might be so bold, Program calls using the
> >AS/400 tool box can tend to be a little slow. I
> always
> >suggest you bundle up your native programs on the
> 400
> >as SQL stored procedures and call them via JDBC.
> Then
> >not only do you get a little faster resonse, you
> get
> >an open service that is callable by any program
> >includeing Java. (And you get to remain platform
> >independant)
> >
> >--- Robert Upshall <rupshall@hotmail.com> wrote:
> >> Hi,
> >>
> >> I am attempting to convert my code to use
> >> ProgramCall instead of
> >> CommandCall, the command call worked fine now we
> >> need to pass values back so
> >> we will need to take advantage of
> ProgramParameter
> >> class.
> >>
> >> Could somebody tell me how I would convert the
> >> CommandCall code below into
> >> ProgramCall.
> >>
> >> // start code snipet
> >> /*
> >> CommandCall cmd = new CommandCall(srvb);
> >>
> >> // run the command
> >> cmd.run(
> >> "CALL GBTINET/GCPLIINET PARM('"
> >> + pGroup
> >> + "' '"
> >> + pSin
> >> + "' '"
> >> + pClass
> >> + "' '"
> >> + pTypKey
> >> + "')");
> >>
> >> // get the message list which contains the result
> of
> >> the command.
> >> AS400Message[] messageList =
> cmd.getMessageList();
> >> */
> >> // end code snipet
> >>
> >>
> >> Thanks in advance for any help
> >>
> >> Robert
> >>
>
>_________________________________________________________________________
> >> Get Your Private, Free E-mail from MSN Hotmail at
> >> http://www.hotmail.com.
> >>
> >> +---
> >> | This is the JAVA/400 Mailing List!
> >> | To submit a new message, send your mail to
> >> JAVA400-L@midrange.com.
> >> | To subscribe to this list send email to
> >> JAVA400-L-SUB@midrange.com.
> >> | To unsubscribe from this list send email to
> >> JAVA400-L-UNSUB@midrange.com.
> >> | Questions should be directed to the list owner:
> >> joe@zappie.net
> >> +---
> >
> >
> >=====
> >Eric Merritt
> >Information Systems Consultant
> >McCormack & Associates, Inc.
> >Rock Hill, South Carolina
> >(V) 803-327-3358 X 225
> >eric@mccinc.com
> >http://www.mccinc.com/
> >
> >__________________________________________________
> >Do You Yahoo!?
> >Get email at your own domain with Yahoo! Mail.
> >http://personal.mail.yahoo.com/?.refer=text
> >+---
> >| This is the JAVA/400 Mailing List!
> >| To submit a new message, send your mail to
> JAVA400-L@midrange.com.
> >| To subscribe to this list send email to
> JAVA400-L-SUB@midrange.com.
> >| To unsubscribe from this list send email to
> JAVA400-L-UNSUB@midrange.com.
> >| Questions should be directed to the list owner:
> joe@zappie.net
> >+---
> 
> +---
> | This is the JAVA/400 Mailing List!
> | To submit a new message, send your mail to
> JAVA400-L@midrange.com.
> | To subscribe to this list send email to
> JAVA400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> JAVA400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner:
> joe@zappie.net
> +---


=====
Eric Merritt
Information Systems Consultant
McCormack & Associates, Inc.
Rock Hill, South Carolina
(V) 803-327-3358 X 225
eric@mccinc.com
http://www.mccinc.com/

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---