Re: trouble converting a sql statement

[CRPence <CRPbottle@xxxxxxxxx>]

On 08 Mar 2013 12:49, CRPence wrote:
>       Exec sql
>        Prepare SQLStatement from :SQLSTRING;
>       // check SQLCODE here
>       Exec Sql
>        Declare db2curs cursor for SQLSTATEMENT ;
>       Exec Sql
>        open C2 using :currentdate, :currentdate, :sts ;

  Of course that /open/ should refer to the db2curs, not C2.  I copied 
the latter from my source used to verify, and those prior were copied 
from the OP.  Ugh :-(  The above was corrected in what appears below 
[just the last line changed]:

        Exec sql
         Prepare SQLStatement from :SQLSTRING;
        // check SQLCODE here
        Exec Sql
         Declare db2curs cursor for SQLSTATEMENT ;
        Exec Sql
         open db2curs using :currentdate, :currentdate, :sts ;