ADS requirements for SQL language procedures

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

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

The 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.

Environment

Release: All supported releases.
Components: ADS, SQL Option.

Resolution

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
   $ACF@TAT
   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.

Additional Information

CREATE PROCEDURE