DECLARE STATEMENT
The DECLARE STATEMENT statement is used for application program documentation. It declares names that are used to identify prepared SQL statements.
Invocation
This statement can only be embedded in an application program. It is not an executable statement.
Authorization
None required.
Syntax
.-,--------------. V | >>-DECLARE----statement-name-+--STATEMENT----------------------><
Description
- statement-name STATEMENT
- Lists one or more names that are used in your application program to identify prepared SQL statements.
Example
This
example shows the use of the DECLARE STATEMENT statement in a PL/I
program.
EXEC SQL DECLARE OBJECT_STATEMENT STATEMENT;
EXEC SQL INCLUDE SQLDA;
EXEC SQL DECLARE C1 CURSOR FOR OBJECT_STATEMENT;
( SOURCE_STATEMENT IS "SELECT DEPTNO, DEPTNAME,
MGRNO FROM DSN8A10.DEPT WHERE ADMRDEPT = 'A00'" )
EXEC SQL PREPARE OBJECT_STATEMENT FROM SOURCE_STATEMENT;
EXEC SQL DESCRIBE OBJECT_STATEMENT INTO SQLDA;
/* Examine SQLDA */
EXEC SQL OPEN C1;
DO WHILE (SQLCODE = 0);
EXEC SQL FETCH C1 USING DESCRIPTOR SQLDA;
/* Print results */
END;
EXEC SQL CLOSE C1;