ADD-LIKE-INDEX( ) method

Adds an index, like the specified source index, to the temp-table.

This method cannot be called after TEMP-TABLE-PREPARE( ) has been called unless CLEAR( ) is called first.

Return type:

LOGICAL

Applies to:

Temp-table object handle

 

Syntax 

ADD-LIKE-INDEX ( index-name-exp , source-index-name-exp   { , source-buffer-handle-exp | source-db-table-name-exp } )

index-name-exp

A character expression that evaluates to the name of the index to which the source index is being copied.

source-index-name-exp

A character expression that evaluates to the name of the index in the source table that is being copied to the temp-table.

source-buffer-handle-exp

A character expression that evaluates to a buffer handle from which to copy the index.

source-db-table-name-exp

A character expression that evaluates to a database table name from which to copy the index.

The following example fragment adds a new index to a temp-table like the name index in the Customer table:

 

tth:ADD-LIKE-INDEX("abidx","name","Customer").