Batch Management Overview › Preparing for Batch Export Function Use

Preparing for Batch Export Function Use

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. This exported data is then available for use in user-written programs.

Types of Export Files

CA Dataquery places the requested exported data in a sequential output file. Thus, you must allocate a data set for the exported data. There are two different types of export output file:

• For export as comma-separated values, the output data set must be a sequential file with variable-length rows and blocked format with a block size of 4096 bytes. The maximum length of any data row is 4088.

  If the user executes more than one comma-separated value EXPORT per any execution of DQBATCH, CA Dataquery writes all of the output sets to the same output sequential data set.

  The exported data set can be downloaded to a PC, since it is in PC file format (CSV).

• For export of fixed-length records, the output data set must be a sequential file with a record length equal to that of the exported rows.

  The user may not execute more than one fixed-length EXPORT per any execution of DQBATCH. If a second fixed-length EXPORT is performed within a single execution of DQBATCH, CA Dataquery overwrites the data from the first EXPORT.

z/VSE Requirements

In a z/VSE environment, the System Option Table EXPDEV= parameter specifies the default device for exported data. This default can be overridden for nondeferred jobs at submit time when the system prompts the user for the device. If the exported files will be stored on disk, you should assign some specific space for that purpose. For more information, see Accessing Exported Data.