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;