|
Add
|
Displays the Table Selector dialog. From this box select any tables not yet selected for the current procedure. After you select a table, the AppBuilder displays it in the Temp-Tables Maintenance box and activates the other options
Note: The AppBuilder uses the ABL "LIKE" syntax to define the Temp-Table. Defining the Temp-Table like an existing table causes the Temp-Table definition to be stored in ther–code during compilation, but does not require the TEMP-DB to be connected at run time. This is necessary because Temporary Tables do not exist until run–time.
|
|
Remove
|
Removes a table definition from the current procedure after you highlight it in the display box.
To apply table properties or other options to a table, highlight it from the displayed list, then select items as described below.
|
|
New Global Shared
|
Establishes a global shared Temporary Table. The scope of a global shared Temporary Table is the session.
|
|
New Shared
|
Establishes a shared Temporary Table. The scope of a shared Temporary Table is the scope of the procedure that established it.
|
|
Shared
|
Allows the procedure to access an established shared Temporary Table.
|
|
Local
|
Allows access only from this procedure. This is the default selection.
|
|
Buffer
|
Defines an extra buffer for the table instead of defining a Temporary Table. As with the Temporary Table, the scope of the buffer is determined by your selection from the properties listed above. For example, if you select "New Shared" and "Buffer", you are defining a new shared buffer.
|
|
NO-UNDO
|
Increases update performance for Temporary Table. If you deselect this button, changes made to the Temporary Table during a transaction are logged to the local before image (LBI) file.
|
|
Table Name
|
Allows you to rename your Temporary Table. The new name is updated in the Temp-Tables list as soon as you leave the fill–in.
|
|
Additional Fields
|
Allows you to add extra fields to a defined Temp-Table. For example, you might want to maintain the schema of an existing database table, but add one or two extra fields. You can also use this fill–in to override the primary index for the table.
Note: Fields entered in Additional fields will not be available for selection in the Query Builder and other AppBuilder schema pickers. Additional Fields is reserved for less visible data, such as ROWID or a time stamp. Fields that you want available from the schema pickers should be defined in the Data Dictionary.
|
|
Check Syntax
|
Checks the syntax of any entries in Additional Fields prior to running or saving your procedure.
|