CONCAT - Special Attribute

This concatenate is designed to add the value of a Special Attribute to the end of an existing view attribute.

The generated statement will do a right trim of the target view attribute plus the "Spaces Between" and the add the specified Special Attribute.

Example:

|  SET export test description TO concat(substr(export test description, 1, 
|       length(trim(export test description)) + 1), USER_ID)