7.98.2 USE Examples
Example 1: Use the built in concatenation functions to concatenate name fields #FIRST, #SECOND and #THIRD into field #NAME in a number of different ways:
USE BUILTIN(CONCAT) WITH_ARGS(#FIRST #SECOND) TO_GET(#NAME)
USE BUILTIN(BCONCAT) WITH_ARGS(#FIRST #SECOND #THIRD) TO_GET(#NAME)
USE BUILTIN(TCONCAT) WITH_ARGS(#SECOND ''', ''' #FIRST) TO_GET(#NAME)
GROUP_BY NAME(#XG_PARMS) FIELDS(#FIRST #SECOND #THIRD)
USE BUILTIN(CONCAT) WITH_ARGS(#XG_PARMS) TO_GET(#NAME)
Example 2: Use Built-In Function UPPERCASE to convert the contents of field #NAME to uppercase:
USE BUILTIN(UPPERCASE) WITH_ARGS(#NAME) TO_GET(#NAME)