Accessing Exported Data

The CA Dataquery batch export function allows the user to export the columns and keys named in the PRINT or DISPLAY statement of the query to an output table in the order specified in the query. The columns and keys named in the PRINT or DISPLAY statements of the query determine the columns in the output row. This exported data is then available for use in user-written programs. The user must be authorized for SUBMIT ALLOWED and EXPORT ALLOWED on the User Table Maintenance panel under the administrative USERS option to be able to use the export function.

Export File Formats

CA Dataquery supports export of data in two formats:

Comma-separated values to a sequential file with variable-length records
Fixed-position fields to a sequential file with fixed-length records

Operation

CA Dataquery places the requested exported data in a sequential output file, therefore you must allocate a data set for the exported data.

The user requests that data be exported by filling in a name for the output set of data records on the Batch Execution panel, or by using the EXPORT command in Sign/On mode in batch CA Dataquery. CA Dataquery exports the data as indicated in the query to the named data set.

The user may also request two types of output, either DETAIL or TOTALS or both. If both types are requested, the output will consist of two sets of output rows, one for DETAIL and one for TOTALS. DETAIL type formats the values of the columns in the PRINT statement of the query in the data row. TOTAL prints subtotals when the data in a SORT column changes.

z/VSE Requirements

For z/VSE, the DQOPTLST option specifies whether the default is tape or disk. This default can be overridden for nondeferred jobs at submit time when the system prompts the user for the device. The user's response must match the device specified in the JCL member. Deferred jobs always take the DQOPTLST value.