You may come across the situation, where you want to concatenate a char or CLOB value to a char or CLOB variable. Sage X3 has a special Keyword named APPEND to perform the concatenation of two or more string values.

From a functional point of view, Append Field1, Field2 is equivalent to Field1+= Field2.  if ‘Field1’ and ‘Field2’ are strings or CLOBs. Execution is fast using Append keyword especially if you build long strings stored in CLOBs.

The output of the above code is following:

Also Read:

– Determine Record Size of Tables in X3

– How to get Row count in Sage X3?

– How to get the number of records which is deleted by Delete Command

– How to get the number of records modified by Update Command

– How to determine if a mask variable can be entered or is displayed..?