Table 12 describes the SQL statement icons.
Icon |
Statement |
Description |
|
Abort |
Terminate the current transaction. |
|
Alter Trigger |
Allow users to enable or disable a trigger, and to change its creation timestamp. |
|
Call Procedure |
Execute a stored procedure. |
|
Create/Replace Macro |
Insert or replace a macro in the database. |
|
Create/Replace Procedure |
Insert or replace a procedure in the database. |
|
Create/Replace Trigger |
Create new triggers or change the definition of a trigger. |
|
Alter Table |
Alter a specified table. |
|
Create Index |
Create an index to table. |
|
Create Table |
Alter a specified table. |
|
Delete |
Delete rows from a table. |
|
Drop Index |
Drops an index on a specified table. |
|
Drop Table |
Drops a specified table. |
|
End Transaction |
Indicate that the processing is complete and any locks on the data can be removed. |
|
Execute Macro |
Execute a specified macro. |
|
Insert |
Add rows to a table. |
|
Merge into |
Merge row or rows into a table. |
|
End Mload |
Signifies the end of a Multiload task and initiates task processing. |
|
Begin Mload |
Signifies the beginning of a Multiload import task. |
|
Mload Job |
Invokes a Multiload job. |
|
Set Check Workload |
Set check workload during Mload. |
|
Checkpoint Loading |
Threshold limits that can be assigned for a specific load for Fastload, Multiload, or TPT. |
|
Begin Loading |
Initiates the loading process. |
|
Query Band |
Sets a query band. |
|
Roll Back |
Terminate the current transaction, and reset the database to the pre‑transaction state. |
|
Select |
Retrieve specified fields from a table. |
|
Update |
Modify data in one or more rows of a table. |