Products Downloads


French version


 

 

      

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

 

↑ Top of page

  • Aucune étiquette