Specifying return options for Data output
By default a data query returns the entire recordset. If some packets within the recordset are not required by your query, you can eliminate them from the query to improve performance.
This applies to XML output only.
These options can be deselected:
Option | Description |
Max Records | Specify the maximum number of records that the query should retrieve |
Columns (COLS) | If selected, the COLS node in the Data output RECKEY node is returned. |
Keys (RECKEY) | If selected, returns key fields. |
Related (RELDRILL) | If selected, returns related fields. |
Count (MAXOUT attribute or RECORDS node) | If selected, provides a count of records that resulted from the query. |
IDA (IDACALL) | Returns Drill-Around information if available. |
Next Refs (NEXTREF) | Include the NEXTREF node in the output. |