XCONCAT

ANSI DB2 SQL/DS XDB
      X

String concatenation can be performed using the XCONCAT function (concatenation can also be performed with the "||" operator). The format appears below:

XCONCAT(expres1, expres2)

The parameters expres1 and expres2 are expressions that evaluate two strings to be concatenated.