RE: dynamic SQL in RPG

James,
Look at the PREPARE and DECLARE SQL statements. They will do what you want.
-Bob


-----Original Message-----
From: rpg400-l-bounces+cozzi=rpgiv.com@xxxxxxxxxxxx
[mailto:rpg400-l-bounces+cozzi=rpgiv.com@xxxxxxxxxxxx] On Behalf Of James
Rich
Sent: Wednesday, March 31, 2004 5:28 PM
To: rpg400-l
Subject: dynamic SQL in RPG

Hi folks,

I've been reading the DB2 UDB for iSeries SQL Programming with Host
Languages V5R1 and I am not finding what I'm looking for.  I want to do
something like this:

if (condition1)
eval  sqlstatement='<one sql statement>'
else
eval  sqlstatement='<an entirely different sql statement>'
endif

and then run the sql query using the string contained in sqlstatement.  I
looked at
http://publib.boulder.ibm.com/iseries/v5r1/ic2924/index.htm?info/rzajp/rzajp
mst144.htm
which is close to what I want to do, but it uses a largely constant
statement (STMT) that allows an embedded variable (i.e. OPEN C1 USING
:EMPNUM).  I want to make the entire select statement variable, including
selection criteria (as in case 1 select by fields A and B and in case 2
select by fields C and D).  How do I do this?

James Rich

Zvpebfbsg vf abg gur nafjre.
Zvpebfbsg vf gur dhrfgvba.
AB (be Yvahk) vf gur nafjre.
        -- Gnxra sebz n .fvtangher sebz fbzrbar sebz gur HX, fbhepr haxabja
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.