Additional information for Db2 SQL

These topics contain additional information for Db2 SQL.

Limits in Db2 for z/OS
Db2 for z/OS® has system limits, object and SQL limits, length limits for identifiers and strings, and limits for certain data type values.
Reserved schema names and reserved words in Db2 for z/OS
Restrictions exist on the use of certain words that are used by Db2 for z/OS. In some cases, these names are reserved and cannot be used by application programs. In other cases, certain names are not recommended for use by application programs though not prevented from being used by the database manager.
Actions allowed on SQL statements
Specific Db2 statements can be executed, prepared interactively or dynamically, or processed by the requester, the server, or the precompiler or coprocessor.
SQL statement data access classification for routines
Certain SQL statements can be executed in a stored procedure or in a user-defined function. Whether the statements can be executed depends on the level of SQL data access with which the routine is defined.
SQL control statements for external SQL procedures
SQL control statements for external SQL procedures can be used only with SQL procedures that are created with the FENCED or EXTERNAL clause. SQL control statements provide the capability to control the logic flow, declare and set variables, and handle warnings and exceptions. Some SQL control statements include other nested SQL statements.
SQL communication area (SQLCA)
An SQLCA is a structure or collection of variables that is updated after each SQL statement executes. An application program that contains executable SQL statements must provide exactly one SQLCA, with a few exceptions.
SQL descriptor area (SQLDA)
An SQLDA is a collection of variables that is required for execution of the SQL DESCRIBE statement, and can be optionally used by the PREPARE, OPEN, FETCH, EXECUTE, and CALL statements. An SQLDA can be used in a DESCRIBE or PREPARE INTO statement, modified with the addresses of host variables, and then reused in a FETCH statement.
Db2 directory tables
Db2 for z/OS maintains a set of tables (in database DSNDB01) called the Db2 directory. Authorized users can query the directory; however, it is primarily intended for use by Db2 and is therefore subject to change.
Db2 XML schema repository tables
The Db2 for z/OS XML schema repository (XSR) is a set of Db2 tables where you can store XML schemas.
Tables that are used for program authorization
Sample user-defined functions
Some sample user-defined functions are provided with Db2. You can use the functions in your applications just as you would use other user-defined functions, or as examples to help you define your own user-defined functions.

Parent topic: SQL: The language of Db2