RE: Problem with delimiters using embedded SQL.

 <snip>
Will place MyVal into the question mark of PriKey.  Yet another reason
why 
SQL kicks butt on OPNQRYF.
</snip>

There's too many ways SQL to count how SQL kicks OPNQRYF's butt....


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, August 23, 2006 2:22 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Problem with delimiters using embedded SQL.

Standard answer.  Been quite repeated on this list lately.  Stop trying
to 
embed the actual value into :w_string.  Imbed "parameter markers"
instead.
w_string = 'select colA from fileA where PriKey=?';
/end-free
C/exec sql
C+  PREPARE S1 FROM :W_STRING
C/end-exec
C/exec sql
C+  DECLARE CURS1 CURSOR FOR S1
C/end-exec
C/exec sql
C+  OPEN CURS1 using :MyVal
C/end-exec

Will place MyVal into the question mark of PriKey.  Yet another reason
why 
SQL kicks butt on OPNQRYF.

Rob Berendt