Re: How to use fetch while calling sql stored procedure in rpg ?

If you mean you are running, say, a VB app using ODBC, yes, you can call a 
stored procedure and get records in the result set(s) from the iSeries. If you 
mean to get data that is on a PC, like in SQL Server, I think you'd need to use 
JDBC, called from your RPG, perhaps, because CLI depends on the DRDA stuff that 
you set up with WRKRDBDIRE. Now if you are talking DB2 on the PC, you can use 
CLI.

-------------- Original message -------------- 
From: mschutte@xxxxxxxxxxxx 

> Any chance that this can be used to return datadase records from a PC? 
> 
> Michael Schutte 
> Work 614-492-7419 
> email michael_schutte@xxxxxxxxxxxx 
> 
> 
> 
> "Steve Richter" 
> > mail.com> To 
> Sent by: "Midrange Systems Technical 
> midrange-l-bounce Discussion" 
> s@xxxxxxxxxxxx 
> cc 
> 
> 03/06/2006 10:12 Subject 
> AM Re: How to use fetch while calling 
> sql stored procedure in rpg ? 
> 
> Please respond to 
> Midrange Systems 
> Technical 
> Discussion 
> > nge.com> 
> 
> 
> 
> 
> 
> 
> On 3/2/06, Vernon Hamberg wrote: 
> > A bit more on using CLI in RPG - did a google on 
> > "sql cli rpg" - turns out Craig Pelkie has done a 
> > lot of work on this. He has a presentation at 
> > http://www.web400.com/Penton/rpg_cli.pdf and the 
> > various resources needed at http://www.web400.com/Penton/rpgcli.html 
> 
> this PDF was good to read thru. I did not know that the current user 
> name and password could be used on the CLI connect statement by 
> leaving those two values blank, 
> 
> I used to tsk, tsk at CLI because it was complex, slow and a security 
> problem what with the password being in the source code. Glad to know 
> there is no need to have the password in the clear. 
> 
> -Steve 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l. 
> 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l. 
>