Output Exit

The Output exit can be invoked in either batch or online CA Dataquery. This exit allows users to access individual rows of output before printing the data on the screen or page. To access a data stream (screen or page image), see Data Stream Output Exit. For details about the OUTXITO= and OUTXITB= parameters of the System Option Table, see DQOPTLST Parameters.

Online Output Exit

In online, the name you specify in the OUTXITO= parameter is the name of the exit you want to call just after a row is read from CA Datacom/DB. Only those rows meeting selection criteria are available to this exit. See DQOPTLST Parameters for information about the valid entries and default value of the OUTXITO= parameter.

A user-written Output Exit for CICS must be a command-level or macro-level CICS program. Information is passed to the user exit in an 80-byte CICS temporary storage record. The user exit reads the temporary storage record. The following is the format for the 8-character name of the temporary storage record:

DQnnnnSO

where nnnn is the CICS terminal ID.

For TSO, this information is provided in the batch interface.

The information passed consists of the following 80-byte area:

  TSURECD   DS      0CL80
  TSURECDA  DS      F      USER RECORD ADDRESS
  TSOPID    DS      CL32   OPERATOR ID
  TSDDREC   DS      CL32   DD RECORD NAME
  TSTBL     DS      CL3    3 BYTE TABLE NAME
  TSDBID    DS      CL2    2 BYTE HEX DBID
  TSFILL    DS      CL7    AVAILABLE

Batch Output Exit

In batch, the name you specify in the OUTXITB= parameter is the name of the exit you want DQBATCH to call just after a row is read from CA Datacom/DB. See DQOPTLST Parameters for information about the valid entries and default value of the OUTXITB= parameter.

Upon entry to the Batch Output Exit:

Register 1

A one word parameter list that is the address of an 80-byte parameter area formatted as follows:

  TSURECD   DS      0CL80
  TSURECDA  DS      F      USER RECORD ADDRESS
  TSOPID    DS      CL32   OPERATOR ID
  TSDDREC   DS      CL32   DD RECORD NAME
  TSTBL     DS      CL3    3-BYTE TABLE NAME
  TSDBID    DS      CL2    2-BYTE HEX DBID
  TSFILL    DS      CL7    AVAILABLE

Register 13

Contains the address of a register SAVE area which you must use to save and restore CA Dataquery's registers according to standard linkage conventions. The exit you name saves the calling program's registers at offset 12 from the address in register 13.

Register 14

Contains the return address within CA Dataquery.

Register 15

Contains the address of the entry point of the exit.

CA Dataquery Batch calls the user Output Exit one time for every row returned by the query. Data can be changed by modifying the row pointed to by TSURECDA.

For samples, see the CA Datacom website. Do not change the column lengths or data types. Numeric cannot be replaced by alphabetic data, and so on.