RE: Creating SQL result set in RPG without 5722ST1

[johnking@xxxxxxx]

Peter,

 Thanks for the tip. So far I've been able to skate around our lack of ST1 by
using the APIs, but in this case was trying to educate myself about how to make
RPG generate a real-live SQL result set and pass it back to something else as a
result set. I'd just assumed I wasn't smart enough to interpret what the SQL
manuals were clearly stating and that Scott or Simon or someone would say "you
dummy, just create a cursor and bind some columns, cross yourself thrice and
seton *INLR", but it appears as though this is something the APIs aren't meant to do.

Many thanks, JK

On Wed 08/10/ 1 15:21 , 'Peter Connell'  sent:
> JK,
> All else failing, you could at least launch an SQL select request by
> writing the SQL statement to a source file and executing that via the
> RUNSQLSTM cmd,
> (not certain if RUNSQLSTM needs ST1) otherwise there is an ancient
> technique for running SQL without ST1 by creating a generic *QMQRY,
> (which, because it accepts parms to embed in the SQL statement, allows
> you to embed the entire statement by passing each part of it as a
> parm).The SQL could insert the result set into a work file which you would
> have to read via RPG. 
>
> But, nothing is easier than Net.data for getting something on the web
> (no cost since you've already got it)
>
> Peter

---- Msg sent via Internet America Webmail - www.internetamerica.com