CREATE-LIKE-SEQUENTIAL( ) method

Creates a table like another existing database table or temp-table. Unlike CREATE-LIKE( ), which creates temp-table fields in metaschema _field._field-rpos order (POSITION order in the .df schema definition file) of the source table’s fields, this method creates fields in _field._order sequence.

Return type:

LOGICAL

Applies to:

Temp-table object handle

You can guarantee agreement of temp-table field order between any client and any AppServer using CREATE-LIKE-SEQUENTIAL( ), as long as the _field._order values are the same. CREATE-LIKE-SEQUENTIAL( ) uses the field order as defined in the Data Dictionary when the source is a database table.

 

Syntax 

CREATE-LIKE-SEQUENTIAL ( { src-buffer-handle-exp | src-table-name-exp }   [ , src-index-name-exp ] )

src-buffer-handle-exp

An expression that evaluates to a buffer handle from which to copy the field definitions, and optionally, the indexes if src-index-name-exp is not specified.

src-table-name-exp

An expression that evaluates to a table name from which to copy the field definitions and, optionally, the indexes if src-index-name-exp is not specified.

src-index-name-exp

A character expression giving an index to be copied from the source table. If this option is specified, only this single index is copied from the source table.

This method copies the field definitions from the specified source table and establishes the default or specified source indexes. You cannot call this method after another definitional method is called unless you call CLEAR( ) first.

Note:

The original behavior of CREATE-LIKE( ) was used to support RAW-TRANSFER with temp-tables. If you are using RAW-TRANSFER between a database table and a temp-table defined LIKE the database table, then you should not use CREATE-LIKE-SEQUENTIAL( ).

See also:

CREATE-LIKE( ) method