Previous Next

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.


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