Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

RUNSQLSTM vs STRQMQRY

335 views
Skip to first unread message

Jean-Claude

unread,
Jun 21, 2005, 2:17:54 PM6/21/05
to
Hello,

RUNSQLSTM can run many statements (using ';' between each one) but cannot
use parameters.
STRQMQRY can run only one statement but can use parameter.

Is there any way (interpreted or compiled) to run many satements using
parameters ? How ?

Thanks.

JC


Chris

unread,
Jun 21, 2005, 3:01:04 PM6/21/05
to
You could embed SQL into an RPG program or you could update the source
file (used by RUNSQLSTM). IE, scan for your value(s), replace w/your
parm(s). This could be in a simple CL.

HTH

Chris

mike

unread,
Jun 21, 2005, 4:00:04 PM6/21/05
to

How about multiple STRQMQRY statements in a compiled cl program with
parameters?


"Jean-Claude" <jean-cla...@wanadoo.fr> wrote in message
news:42b859c5$0$1255$8fcf...@news.wanadoo.fr...

Birgitta Hauser

unread,
Jun 23, 2005, 10:18:13 AM6/23/05
to
What about creating a SQL defined stored procedure and call it from
STRQMQRY?
An SQL stored procedure can have input and output parameters and
execute several SQL statements.

For more information about stored procedures, look at one of the
following redbooks:
1. <a href="http://www.redbooks.ibm.com/abstracts/sg246393.html?Open"
target="_Blank">Modernizing IBM eServer iSeries Application Data
Access - A Roadmap Cornerstone</a>
2. <a href="http://www.redbooks.ibm.com/abstracts/sg246503.html?Open"
target="_Blank">Stored Procedures, Triggers and User Defined Functions
on DB2 Universal Database for iSeries
</a>

Birgitta

"Jean-Claude" <jean-cla...@wanadoo.fr> wrote in message news:<42b859c5$0$1255$8fcf...@news.wanadoo.fr>...

0 new messages