Accessing CA Datacom/DB Tables with the Reporting Facility › User Requirements Table Processing

User Requirements Table Processing

When you access a CA Datacom/DB table in a Reporting Facility program, a User Requirements Table is automatically supplied by the Reporting Facility. Select the option at compilation time using the DBCOMM= parameter of the OPTION command in the following command format:

►►─ OPTION ─ DBCOMM= ─┬─ phasename ─┬─┬─────────┬──┬───────────────┬──────────►◄
                      └─ AUTO ──────┘ └─ DBPRI= ┘  └─ DBSEQBUF(s)= ┘

AUTO

Specifies that the Reporting Facility will automatically generate the User Requirements Table entries.

phasename

Specifies the name of a precataloged User Requirements Table that contains entries for each CA Datacom/DB table to be accessed in a single run. The User Requirements Table is loaded from the system library and is used for all database access.

When the User Requirements Table is generated automatically, the Reporting Facility chooses specific default values to define the CA Datacom/DB environment. The system creates a single entry in the table, one for each table defined in the program.

• Supply the table name and database ID by using the FILE command.
• Assume that the CA Datacom/DB Multi-User Facility (MUF) is being used.
• Random and sequential access is allowed.
• File synonyms are allowed.
• Update is not allowed.
• Two sequential buffers are reserved for each table that is, DBSEQBUFS=2.

When the options and parameters chosen by the Reporting Facility are not sufficient to describe the CA Datacom/DB environment, use OPTION DBCOMM=phasename. This allows you to preassemble the User Requirements Table using any available options that specifically pertain to accessing the database tables.