Difference between revisions of "XML SCATTER()"

Revision as of 10:23, 7 December 2012

Purpose

Return the contents of a record formatted as XML

Syntax

XML_SCATTER([<expN>|<expC>])

See Also

MQCLOSE(), MQCREATE(), MQCURMSGS(), MQOPEN(), MQSEND(), MQRECEIVE(), MQUNLINK(), XML, XML_DECODE(), XML_ENCODE(), XML_GATHER()

Description

The XML_SCATTER() function returns a character string containing the contents of the current record in the current table formatted as XML. If the optional workarea number <expN> or alias name <expC> is specified, the function will operate on the table referenced.

Example

open database southwind
use shippers
cVar = xml_scatter()