RE: Creating SQL result set in RPG without 5722ST1

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