ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
ADS requirements for SQL language procedures
Article ID: 125214
Updated On:
Products
IDMS
IDMS - Database
IDMS - ADS
Issue/Introduction
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.
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.
Environment
CA-IDMS, all supported releases.
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
[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.
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.
Additional Information
Feedback
Yes
No
Powered by
