QuickBridge: CAAVLREC and CAAVMTXT, batch or online?
search cancel

QuickBridge: CAAVLREC and CAAVMTXT, batch or online?

book

Article ID: 92137

calendar_today

Updated On:

Products

IDMS IDMS - Database IDMS - ADS

Issue/Introduction

When installing SQL QuickBridge, two cobol programs for implementing table procedures are provided, CAAVLREC and CAAVMTXT.
As provided, the source has them defined as BATCH programs.

Clearly, CAAVLREC and CAAVMTXT must sometimes run under the control of the CA-IDMS/DC address space (online).
Doesn't that mean that they should be compiled as online programs, i.e. MODE IS IDMS-DC ?

Environment

CA-IDMS, all supported releases.

Resolution

Table procedure programs can conceivably be called in any of online, batch-CV and batch-local environments.
For such programs, if they are compiled as batch programs (MODE IS BATCH), they can be called in an online environment, but the reverse is not true - if they are compiled as online programs (MODE IS IDMS-DC), then they won't run in a batch environment.
Therefore it is recommend that they be compiled as batch programs, and linked to a library available to both batch jobs and CVs.
They also need to be defined to sysgen.
This recommendation applies to all user-written table procedure programs, not just CAAVLREC and CAAVMTXT.

Additional Information

Using SQL Quick Bridge
Defining and Using Table Procedures
ENVIRONMENT DIVISION (in "DML Reference for COBOL")