Index  Home

Append

Append allows to concatenate a char or CLOB value to a char or CLOB variable.

Syntax

 Append VAR1, EXPRESSION2
* **`VAR1`** is a variable with one of the following syntaxes:* VARIABLE_NAME* VARIABLE_NAME (INDEX_EXPRESSION_LIST)* **`EXPRESSION2`** is an expression returning a string or a CLOB.* **`INDEX_EXPRESSION_LIST`** is a list of expressions returning an integer used when "VARIABLE_NAME" corresponds to an array. It gives the current index in the array. The number of elements on the list must correspond to the number of dimensions of the array.

Examples

 # Example 1Local Clbfile FIELD1Local Char FIELD2FIELD1="A"FIELD2="2"APPEND FIELD1, FIELD2# Now FIELD1 contains "A2"# Example 2Local Clbfile FIELD1Local Clbfile FIELD2FIELD1="A"FIELD2="2"APPEND FIELD1, FIELD2# Now FIELD1 contains "A2"# Example 3Local Char FIELD1FIELD1="A"APPEND FIELD, "2"# Now FIELD1 contains "A2"

Description

Append allows to concatenate a string or CLOB value to an existing string or CLOB.

From a functional point of view, Append A,B is equivalent to A+=B if 'A' and 'B' are strings or CLOBs.

Execution is fast especially if you build long strings stored in CLOBs.

Associated errors

None

See also

Clbfile, Char, Schar.


Index  Home