Support for SQL and commands

Automatic generation of statements and commands is one way that File-AID for Db2 Object Administration can save time for you and reduce the complexity of Db2. Defaults are provided for all parameters, which you can edit before generating the statements or commands.

Since the first step in automatic statement or command generation is displaying the objects, please read Catalog and Subsystem Access before this section. Step-by-step instructions for generating and executing SQL, JCL, Db2 commands and DSN subcommands are in Part 2, User space.

File-AID for Db2 Object Administration work buffers are an essential part of generating statements and commands. A work buffer is a temporary storage area for generated statements. Each type of statement, such as JCL, has its own buffer. This section describes how to work with each type of buffer, including retrieving and executing buffer contents.

This section provides information about the following topics:


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*