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
|
|