OK, yes, I am very green. The answer (to both questions) is to use dynamic
SQL instead of static SQL.

Frank

>>> Frank Swarbrick<Frank.Swarbrick@efirstbank.com> 09/20/06 11:59 AM >>>
Given the following COBOL statements with embedded SQL...

Select-ppissue.
EXEC SQL DECLARE c1 CURSOR FOR
SELECT
ACCOUNT_NUMBER,


SERIAL_NUMBER,


AMOUNT,


ISSUED_DATETIME,


PAYEE_NAME


FROM ICM_POSPAY_ISSUED_CHECKS
END-EXEC

EXEC SQL OPEN c1
END-EXEC