|
VADELIA |
SADELIA |
WADELIA |
MADELIA |
|
(I/B) (S) |
(B) (S) |
(I/B) (S) |
(I) (S) |
Section for use
All
Syntax
CREATE_TABLE TableOrEntityName
Description
This instruction lets you create the temporary table TableorEntityName.
TableorEntityName can be:
-
- a name from the declarative instruction TEMP_TABLE present in the program,
- a logical entity name for which the 'Temporary table' box is checked in the LDM.
Note:
Creating the TableName temporary table generates creation of (temporary) accesses associated with the referred entity.
Once the table is created, the Adelia SQL instructions let you manage its data (in the program creating the table and in any subsequently-called programs).
- If the operation is successful, the *RETURN_CODE reserved word is set to 0.
- If the table creation fails, it is set to 1.
- If the creation of any of the table's accesses fails, it is set to 2.
Failure to create one access does not prevent any following accesses from being created. If the creation of the temporary table fails, however, no accesses are created.
The *SQLCODE reserved word contains the result of the last table or access creation operation.
Example
TEMP_TABLE ORD_TMP *REF_LDM(ORDER)
CREATE_TABLE ORD_TMP