Specifying data by using CONCAT

For performance-critical applications, you can use the built-in function REC2XML. You can also use the built-in operator CONCAT or the corresponding characters || in a sequence to construct the type DM_ApplicationData.
For example, the following calls correspond to the example that is described in Specifying data by using DM_applData.
IDMMX.DM_impApplData('<row><column name="CHARCOL">'
||CHARCOL||'</column> '||'column name="DOUBLECOL">'
  ||CHAR(DOUBLECOL)||'</column></row>')
If the columns CHARCOL and DOUBLECOL have NULL values, you must call CONCAT as follows:
IDMMX.DM_impApplData('<row><column name="CHARCOL"'
||coalesce('>'||CHARCOL,' null="true">'
)||'</column>'||'<column name="DOUBLECOL"'
||coalesce('>'||CHAR(DOUBLECOL),' null="true">'
)||'</column></row>')
Note: IM for Data handles date values and time values in a character ISO format. You might want to specify a date value or a time value as CONCAT operator, and you might want to apply a model created by IM for Data. In this case, the date value and the time value must be converted to character ISO format. To do this, use CHAR(<value>, ISO) for a date value and CHAR(<value>, JIS) for a time value.


Feedback | Information roadmap