Temp-table object handle

A handle to a temp-table object. A temp-table object handle corresponds to an underlying ABL temp-table, which can be static or dynamic. A static temp-table is one you define at compile time with the DEFINE TEMP-TABLE statement. A dynamic temp-table is one you create at run time with the CREATE TEMP-TABLE statement.

Syntax

temp-table-handle [ :attribute | :method ]

temp-table-handle: An item of type HANDLE representing a handle to a temp-table object.
attribute: An attribute of the temp-table object.
method: A method of the temp-table object.

Attributes

ADM-DATA attribute	AFTER-TABLE attribute	BEFORE-TABLE attribute
DATA-SOURCE-MODIFIED attribute	DEFAULT-BUFFER-HANDLE attribute	DYNAMIC attribute
ERROR attribute	ERROR-STRING attribute	HANDLE attribute
HAS-RECORDS attribute	INSTANTIATING-PROCEDURE attribute	MIN-SCHEMA-MARSHAL attribute
NAME attribute	NAMESPACE-PREFIX attribute	NAMESPACE-URI attribute
NO-SCHEMA-MARSHAL attribute	NUM-REFERENCES attribute	ORIGIN-HANDLE attribute
PREPARED attribute	PRIMARY attribute	PRIVATE-DATA attribute
REJECTED attribute	SCHEMA-MARSHAL attribute	SERIALIZE-NAME attribute
TRACKING-CHANGES attribute	TYPE attribute	UNDO attribute
UNIQUE-ID attribute	XML-NODE-NAME attribute	–

Methods

ADD-FIELDS-FROM( ) method	ADD-INDEX-FIELD( ) method
ADD-LIKE-FIELD( ) method	ADD-LIKE-INDEX( ) method
ADD-NEW-FIELD( ) method	ADD-NEW-INDEX( ) method
CLEAR( ) method (Temp-Table Object Handle)	COPY-TEMP-TABLE( ) method
CREATE-LIKE( ) method	CREATE-LIKE-SEQUENTIAL( ) method
EMPTY-TEMP-TABLE( ) method	READ-JSON( ) method
READ-XML( ) method	READ-XMLSCHEMA( ) method
TEMP-TABLE-PREPARE( ) method	WRITE-JSON( ) method
WRITE-XML( ) method	WRITE-XMLSCHEMA( ) method

Example

The following code fragment demonstrates the creation, definition and use of a temp-table object:

DEFINE VARIABLE tth             AS HANDLE NO-UNDO.
DEFINE VARIABLE bh              AS HANDLE NO-UNDO.
DEFINE VARIABLE qh              AS HANDLE NO-UNDO.
DEFINE VARIABLE buf-cust-handle AS HANDLE NO-UNDO.

/* Get db table handle as usual */
buf-cust-handle = BUFFER Customer:HANDLE.
/* Create an "empty" undefined temp-table */
CREATE TEMP-TABLE tth.
/* Give it Customer's fields and indexes */
tth:CREATE-LIKE(buf-cust-handle).
/* Give it a single extra field */
tth:ADD-NEW-FIELD("f1","integer").
/* No more fields or indexes will be added to custx */
tth:TEMP-TABLE-PREPARE("custx").
/* Get the buffer handle for the temp-table */
bh = tth:DEFAULT-BUFFER-HANDLE.
/* Populate the table from Customer table */
FOR EACH Customer NO-LOCK:
  bh:BUFFER-CREATE.
  bh:BUFFER-COPY(buf-cust-handle).
END.
/* Run a query to access it*/
CREATE QUERY qh.
qh:SET-BUFFERS(bh).
qh:QUERY-PREPARE("FOR EACH custx WHERE . . .").
. . .

Notes

The temp-table object has three states, CLEAR, UNPREPARED and PREPARED. The temp-table is in a CLEAR state either when the temp-table is first created or immediately after the CLEAR( ) method is applied. The temp-table is in an UNPREPARED state during the period after the first definitional method has been applied and before the TEMP-TABLE-PREPARE( ) method is applied. The temp-table is in a PREPARED state after the TEMP-TABLE-PREPARE( ) method has been applied.
The user can discern whether the temp-table is in an UNPREPARED or PREPARED state by using the PREPARED attribute.