DECLARE STATEMENT statement

The DECLARE STATEMENT statement is used for application program documentation. It declares names that are used to identify prepared SQL statements.

Invocation for DECLARE STATEMENT

This statement can only be embedded in an application program. It is not an executable statement.

Authorization for DECLARE STATEMENT

None required.

Syntax for DECLARE STATEMENT

Description for DECLARE STATEMENT

statement-name STATEMENT: Lists one or more names that are used in your application program to identify prepared SQL statements.

Example for DECLARE STATEMENT

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 DSN8D10.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;