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 application server 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-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. This can be a buffer for either a temp-table or database.

src-table-handle-exp

An expression that evaluates to a temp-table 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 the name of a temp-table or database table 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.

See also

CREATE-LIKE( ) method