Re: Simple SQL in RPG question.

[rob@xxxxxxxxx]

1 - You do not need to use a cursor on a single row fetch!  You can do a 
direct 'select into' instead of a declare, open, fetch, close.
2 - I already gave you an example of using "parameter markers" in that 
code sample I gave you.  Remember the
       stmt1='select cnum, lname, fname ' +
             'into :cnum, :lname, :fname ' +
             'from customer where cnum=?';
      /end-free
     C/EXEC SQL
     C+ Prepare S1 from :stmt1
     C/END-EXEC
...
     C/EXEC SQL
     C+ Execute S1 using :ThisCust
     C/END-EXEC

See the 'where cnum=?'?  ThisCust would be what was passed into the 
program, or prompted from the screen.


Rob Berendt