SEO

#1 (**permalink**) 02-27-2008, 08:16 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

#2 (**permalink**) 02-27-2008, 08:18 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

dynamic cursor name?