The implementation of SQL language procedures in CA-IDMS uses ADS under the covers. This article documents the minimum ADS requirements for the support of SQL language procedures.

The CA-IDMS install process should ensure that the components of ADS necessary for the support of SQL language procedures are installed even if ADS is not specifically being installed.
In the event of a CV not having all of the necessary components for any reason (most likely historical), this document lists the minimum ADS requirements needed.

CA-IDMS, all supported releases.

1.
The following new load modules must exist in CDMSLIB and must be defined to SYSGEN (source in CAGJSRC install member DLODDB/DNODDB):
ADSOCCOM
IDMSGDIA
IDMSGSTA
IDMSSQ2A

2.
The following existing load modules must exist in CDMSLIB and must be defined to SYSGEN (source in CAGJSRC install member DLODDB/DNODDB):
ADSOCDGN
ADSOGEN2
ADSORUN1
[email protected]
ADSOMAIN (SYSGEN source is in CAGJSRC install member DLODADSO/DNODADSO)

3.
An ADSO SYSGEN statement must be present.

4.
An ADSOOPTI module must be present.

5.
The following records must be present in the DDLDML area included in any catalog containing SQL language procedures (source in CAGJSRC install member ADSRECSQ):
ADSO-SQLPROC-COM-AREA
SQLCA
SQLCIB
SQLPIB
SQLRPB
SQLSSI

6.
The following record must be present in the DDLDML area included in any catalog containing SQL language procedures (source in CAGJSRC install member ADSRECST):
ADSO-STAT-DEF-REC

7.
Ensure that up-to-date versions of TABLEDDL and VIEWDDL from install member CAGJSRC are installed.

CREATE PROCEDURE