XMLNEXT()

Purpose

Function to read the next record contained in the XML file specified with the XMLFIRST() function and return the number of fields in the record

Syntax

XMLNEXT(<memvar1>, <memvar2>, <array1>, <array2>)

See Also

COPY, FETCH, PRINT_XML(), SELECT, SET XMLFORMAT, UPDATE, XML, XML_DECODE(), XML_ENCODE(), XML_GATHER(), XML_SCATTER(), XMLCOUNT(), XMLCREATEDTD(), XMLFIRST(), XMLVALIDATE(), XQUERY(), XQUERY ATTRIBUTES(), XQUERY_CLOSE(), XQUERY_COUNT(), XQUERY_DECODE(), XQUERY_FILE(), XQUERY_FIND(), XQUERY_NODE(), XQUERY_OPEN(), XQUERY_SELECT()

Description

The XMLNEXT() function will read the next record contained in the XML file specified with the XMLFIRST() function, returning the number of fields in the record. The XMLFIRST() function must be called first before the XMLNEXT() function can be used.

Parameters	Required	Default	Description
<memvar1>	Yes	None	The name of a memory variable that will return the transaction type for the record. Valid types are INSERT, UPDATE and DELETE.
<memvar2>	Yes	None	The name of a memory variable that will return the where condition for the transaction if it is an UPDATE or DELETE type.
<array1>	Yes	None	The name of an array that will be created that contains all the field names for the record.
<array2>	Yes	None	The name of an array that will be created that contains all the data each field for the record.

The XMLNEXT() function will return -1 if it fails or where there are no more records left in the XML file, as some transaction type can contain zero fields.

Example

number = xmlnext(trans, where, names, data)
? number
        30