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 (Handle)	COPY-TEMP-TABLE( ) method
CREATE-LIKE( ) method	CREATE-LIKE-SEQUENTIAL( ) 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.

See also

Buffer object handle, CREATE TEMP-TABLE statement, DEFINE TEMP-TABLE statement, ProDataSet object handle

OpenEdge Release 10.2B

Copyright © 2009 Progress Software Corporation