XML.SQLStatementExport

The XML SQLStatementExport method works in a similar fashion to the SQLExport method. For both methods, the XML document generated has the same format (for more information on the format, see also: "The XML.SQLExport Method"). The difference is that SQLStatementExport executes a dynamic statement passed as the input parameter.

Syntax

INVOKE     XML.Sq1StatementExport WITH

SELECT     sql-statement-as-string

Example 1

INVOKE     XML.SQLStatementExport WITH

SELECT     'select * from employee'

Example 2

INVOKE     XML.SQLStatementExport WITH

SELECT     sql-statement

FROM       my-report-table