Re: ProgramCall and ProgramParameter classes

["Bruce Jin" <brucej@xxxxxxxxxxxxxxxxxxxx>]

Eric thanks for the info.

I tried a few jdbc procedure calls and it appears that this approach is
quite handy to use in calling RPG, CL etc. I wonder why one should use
Toolbox.

I found that:

1. JNI offers superb performance but it is not easy to use and it does not
work with existing AS400 programs.
2. ToolBox is not very easy to use.
3. PCML is not easy to use.
4. JDBC procedure call is very easy to use. And one does not have to use
jt400.zip file.

Any comments anybody?

Thanks
Bruce

-----Original Message-----
From: Eric Merritt <cyberlync@yahoo.com>
To: JAVA400-L@midrange.com <JAVA400-L@midrange.com>
Date: Friday, March 30, 2001 2:36 PM
Subject: Re: ProgramCall and ProgramParameter classes


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

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