Re: ProgramCall and ProgramParameter classes

["Bruce Jin" <brucej@xxxxxxxxxxxxxxxxxxxx>]

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