Reporting Facility Commands › FILE Command › CA Dataquery DQF Table Definition

CA Dataquery DQF Table Definition

This format of the FILE command describes the attributes of a CA Dataquery found table. Through techniques described in the CA Dataquery documentation, it is possible to perform an online query and store the extracted data as a member on the CA Dataquery found table. CA Dataquery supplies this function to allow batch applications access to data preselected from an online system such as CA Dataquery.

Remember that the CA Dataquery found table is a CA Datacom/DB table. The only way that the Reporting Facility is able to distinguish the difference between a standard CA Datacom/DB table and a CA Dataquery found table is that the first three characters of the table name of the CA Dataquery found table are DQF.

This FILE command is coded as follows:

►►─┬─ DQF ───────┬─┬─ INPUT ─┬─ DATACOM ─ ',parm1,parm2,parm3' ───────────────►
   └─ DQF qual: ─┘ └─ FILE ──┘

 ►─ RECORD=nnn ─┬───────────────┬─┬─────────────┬─────────────────────────────►◄
                └─ NAME=dbname ─┘ └─ DBID=dbid ─┘

DQF qual:

Is a unique file name within the Reporting Facility program. The characters DQF in positions 1—3 of the file name are required to identify this file as a CA Dataquery file. Use qual to provide a unique file name when multiple CA Dataquery tables are specified in a single Reporting Facility run.

A one-character alphanumeric field is automatically generated by the Reporting Facility with the same name as the file name (without the colon), and is used as a return code in conjunction with the GET command.

',parm1

Specifies the predefined, eight-character member name of the collection of data to be retrieved from the CA Dataquery table. It is assigned by the online CA Dataquery operator at the time the data is extracted.

,parm2

Specifies the CA Dataquery operator ID under which the member was created. This parameter is required and can contain a maximum of 32 characters.

,parm3'

Specifies the CA Dataquery password assigned when the member was created. This parameter is required only if a password was assigned when the collection was created. When coded, a maximum of nine characters can be supplied, and it must match the password assigned by the CA Dataquery operator.

RECORD=nnn

Specifies the total length of the data record to be retrieved from the DQF table. The additional 300 characters at the front of the I/O area, required for normal CA Datacom/DB table access, are not required for access to the CA Dataquery table.

NAME=dbname

Optionally specifies the three-character CA Datacom/DB table name needed to access the DQF table.

DBID=dbid

Specifies the numeric database ID in which the DQF table resides. When coded, it must specify a positive integer in the range 1—5000.

Note the following:

• For a more detailed description of the creation of the CA Dataquery found tables, see the CA Dataquery documentation on the EXTRACT function.
• Retrieve a record from the found table by issuing a GET command. The Reporting Facility allows only sequential access to the table. The Reporting Facility controls the access method internally and you issue no alternate CA Datacom/DB commands against the table.
• Although data collected from the online CA Dataquery system is a subset of a common CA Datacom/DB table, the Reporting Facility accesses the member as though it were a flat sequential file.
• You can access multiple extracted members in a single run of the Reporting Facility as long as you define and access each one separately.
• The database ID must be specified in DBID=dbid or in the DQF qual.