INCLUDE

The INCLUDE preprocessor directive is used in an application program to declare the SQLCA or the SQLDA.

Application Programs Only


  INCLUDE {SQLCA [[IS]EXTERNAL]
           SQLDA                }

SQLCA and SQLDA

identify data structures with special predefined meaning as follows:

SQLCA is an area for ALLBASE/SQL output messages concerning the status of each SQL statement.
SQLDA is an area for use in conjunction with dynamic preprocessing of SELECT statements.

Refer to the ALLBASE/SQL Application Programming Guide for the language you are using for more information on these data structures.

IS EXTERNAL

for the COBOL preprocessor only; declares the SQLCA structure as EXTERNAL. Then the SQLCA will not have to be passed explicitly to subprograms.

This directive cannot be used interactively or in procedures.
You must always include the SQLCA in your ALLBASE/SQL application programs by using the INCLUDE statement or explicitly declaring the SQLCA yourself. At run time, ALLBASE/SQL puts information into the SQLCA that describes how SQL statements in the program executed.

You do not need authorization to use the INCLUDE statement.


   INCLUDE SQLCA IS EXTERNAL

   INCLUDE SQLDA

INSERT