integrated information support system (iiss) neutral … · integrated information support system...
TRANSCRIPT
![Page 1: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/1.jpg)
WRDC-TR-90-8007Volume VPart 14
AD-A250 454
INTEGRATED INFORMATION SUPPORT SYSTEM (IISS)Volume V - Common Data Model SubsystemPart 14 - Neutral Data Manipulation Language (NDML) PrecompilerTransform NDML Request from External Schema to Conceptual SchemaProduct Specification
IDTICW9M. Apicella, J. Slaton, B. Levi F O TE.-Control Data Corporation M 0 1992Integration Technology Services2970 Presidential DriveFairborn, OH 45324-6209
September 1990
Final Report for Period 1 April 1987 - 31 December 1990
* Approved for Public Release; Distribution is Unlimited
MANUFACTURING TECHNOLOGY DIRECTORATEWRIGHT RESEARCH AND DEVELOPMENT CENTERAIR FORCE SYSTEMS COMMANDWRIGHT-PATTERSON AIR FORCE BASE, OHIO 45433-6533
92-12197
![Page 2: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/2.jpg)
NOTICEA
When Government drawings, specifications, or other data are used for any purpose otherthan in connection with a definitely related Government procurement operation, the UnitedStates Government thereby incurs no responsibility nor any obligation whatsoever, regardlesswhether or not the government may have formulated, furnished, or in any way supplied thesaid drawings, specifications, or other data. It should not, therefore, be construed or impliedby any person, persons, or organization that the Government is licensing or conveying anyrights or permission to manufacture, use, or market any patented invention that may in any waybe related thereto.
This technical report has been reviewed and is approved for publication.
This report is releasable to the National TechnicalInformation Service (NTIS). At NTIS, it viii be
available to the general public, including foreign nations
DA D L. J S N, Pr"Ject Manager DATE
Wri t-Pat rs AFB, OH 45433-6533
FOR THE COMMANDER:
8RUCE A. RASMUSSEN, Chief DATE y"WRDC/MTWright-Patterson AFB, OH 45433-6533
If your address has changed, if you wish to be removed form our mailing list, or if theaddressee is no longer employed by your organization please notify WRDC/MTI, Wright-Patterson Air Force Base, OH 45433-6533 to help us maintain a current mailing list.
Copies of this report should not be returned unless return is required by securityconsiderations, contractual obligations, or notice on a specific document.
![Page 3: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/3.jpg)
WRDC-TR-90-8007Volume VPart 14
INTEGRATED INFORMATION SUPPORT SYSTEM (IISS)Vol ime V - Common Data Model SubsystemPart 14 - Neutral Data Manipulation Language (NDML) PrecompilerTransform NDML Request from External Schema to Conceptual SchemaProduct Specification
M. Apicella, J. Slaton, B. Levi
Control Data Corporationintegration Technoloay Services2970 Pres-'ential veFairbcrr., OH 4532-1 5209
September 1990
Final Report for Period 1 April 1987 - 31 December 1990
Approved for Public Release; Distribution is Unlimited
_"F:A:T'z.'. TECHNOLOGY DIRECTORATEVPHRESEARCH AND DEVELCPIMEIT CEN- R
A:R"- FORCE SYSTEMS CC"MA,>-,B. I 436.... :H-PA::ERS: AIR FRCEn BASE, OHIO 45433-6533
![Page 4: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/4.jpg)
NOTICE
When Government drawings, specifications, or other data are used for any purpose otherthan in connection with a definitely related Government procurement operation, the UnitedStates Government thereby incurs no responsibility nor any obligation whatsoever, regardlesswhether or not the government may have formulated, furnished, or in any way supplied thesaid drawings, specifications, or other data. It should not, therefore, be construed or impliedby any person, persons, or organization that the Government is licensing or conveying anyrights or permission to manufacture, use, or market any patented invention that may in any waybe related thereto.
This technical report has been reviewed and is approved for publication.
This report is releasable to the National TechnicalInformation Service (NTIS). At NTIS, it will be
available to the general public, including foreign nations
DAN D L. J SON, Pr ject Manager DATE
Wri hta rsJAFB, OH 45433-6533
FOR THE COMMANDER:
bRUCE A. RASIUSSEN, Chief DATE u
WRDC/MTIWright-Patterson AFB, OH 45433-653;
If your address has changed, if you !, .h to be removed form our mailing list, or if theaddressee is no longer employed by yo,:: - -,anization please notify WRDC/MTI, Wright-Patterson Air Force Base, OH 45433-0,Y to help us maintain a current mailing list.
Copies of this report should not be -.c:urned unless return is required by securityconsiderations, contractual obligations. or ..(,tice on a specific document.
![Page 5: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/5.jpg)
Unclassified
SECURVTY CLASSIFICATION OF THIS PAGE
REPORT DOCUMENTATION PAGEla. REPORT SECURITY CLASSIFICATION lb. RESTRICTIVE MARKINGS
Unclassified
2a. SECURITY CLASSIFICATION AUTHORITY 3. DISTRIBUTION/AVAILABILITY OF REPORT
Approved for Public Release;2b. DECLASSIFICATION/DOWNGRADING SCHEDULE Distibution is Unlimited.
4. PERFORMING ORGANIZATION REPORT NUMBER(S) 5. MONITORING ORGANIZATION REPORT NUMBER(S)
PS 620341231 VVRDC-TR-90-8007 Vol. V, Part 14
6a. NAME OF PERFORMING ORGANIZATION 6b. OFFICE SYMBOL 7a. NAME OF MONITORING ORGANIZATIONControl Data Corporation; (if applicable) WRDC/MTIIntegration Technology Services
&c. ADDRESS (City, State, and ZIP Code) 7b. ADDRESS (City, State, and ZIP Code)2970 Presidential DriveFairbom, OH 45324-6209 WPAFB, OH 45433-6533
8a. NAME OF FUNDING/SPONSORING Bb. OFFICE SYMBOL 9. PROCUREMENT INSTRUMENT IDENTIFICATION NUM.ORGANIZATION (if applicable)
Wright Research and Development Center, F33600-87-C-0464Air Force Systems Command, USAF WRDC/MTI
10. SOURCE OF FUNDING NOS.8c. ADDRESS (City, State, and ZIP Code)
Wright-Patterson AFB, Ohio 45433-6533 PROGRAM PROJECT TASK WORK UNITELEFMENT NO. NO. I NO. I NO.
11. TITLE linclude S.curitv Cla..qificr tinnE
See block 19 78011F 595600 F95600 20950607
li. t't":)MUNAL AU I HUHI(Z)
Control Data Corporation: Apicella, M. L., Slaton, J., Levi, B.
13a. TYPE OF REPORT 113b. TIME COVERED 114. DATE OF REPORT (Yr.,Mo.,Day) 15. PAGE COUNTFinal Report 4/l/87-12/31/90 1990 September 30 221
16. SUPPLEMENTARY NO IAI IU N
WRDC/MTI Project Priority 6203
17. COSATI CODES 18. SUBJECT TERMS (Continue on reverse if necessary and identify block no.)
FIELD GROUP SUB GR.
1308 10905
19. ABSTRACT (Continue on reverse if necessary and identify block number)
This specification establishes the design of Function PRE4, "Transform ES/CS", one of the major functions of the ConfigurationItem "Precompiler" to be built and formally accepted by the ICAM program office.
BLOCK 11 :
INTEGRATED INFORMATION SUPPORT SYSTEM
Vol V - Common Data Model Subsystem
Part 14 - Neutral Data Manipulation Language (NDML)Precompiler Transform
NDML Request from External Schema to Conceptual Schema Product
Specification
20. DISTRIBUTION'AVAILABILITY OF ABSTRACT 21. ABSTRACT SECURITY CL.,SSIFICATION
UNCLASSIFIED,'UNLIMITED x SAME AS RPT. DTIC USERS Unclassified
22a. NAME OF RESPONSIBLE INDIVIDUAL 22b. TELEPHONE NO 22c. OFFICE SYMBOLI (Include Area Code)
David L. Judson (513) 255-7371 WRDC'MTI
EDITION OF 1 JAN 73 IS OBSOLETEDD FORM 1473,83 APR Unclassified
SECURITY CLASSIFICATION OF TH!S PAGE
![Page 6: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/6.jpg)
PS 62034123130 September 1990
FOREWORD
This technical report covers work performed under Air ForceContract F33600-87-C-0464, DAPro Project. This contract issponsored by the Manufacturing Technology Directorate, Air ForceSystems Command, Wright-Patterson Air Force Base, Ohio. It wasadministered under the technical direction of Mr. Bruce A.Rasmussen, Branch Chief, integration Technology Division,Manufacturing Technology Directorate, through Mr. David L. Judson,Project Manager. The Prime Contractor was Integration TechnologyServices, Software Programs Division, of the Control DataCorporation, Dayton, Ohio, under the direction of Mr. W. A.Osborne. The DAPro Project Manager for Control Data Corporationwas Mr. Jimmy P. Maxwell.
The DAPro project was created to continue the development, test,and demonstration of the Integrated Information Support System(IISS) . The IISS technology work comprises enhancements to IISSsoftware and the establishment and operation of IISS test bedhardware and communications for developers and users.
The following list names the Control Data Corporationsubcontractors and their contributing activities:
SUBCONTRACTOR ROLE
Control Data Corporation Responsible for the overall CommonData Model design development andimplementation, IISS integration andtest, and technology transfer of IISS.
D. Appleton Company Responsible for providing softwareinformation services for the CommonData Model and IDEFlX integrationmethodology.
ONTEK Responsible for defining and testing arepresentative integrated system basein Artificial Intelligence techniquesto establish fitness for use.
Simpact Corporation Responsible for Communicationdevelopment.
Structural Dynamics Responsible for User Interfaces,Research Corporation Virtual Terminal Interface,and Network
Transaction Manager design,development, implementation, andsupport.
Arizona State University Responsible for test bed operationsand support.
iii
![Page 7: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/7.jpg)
PS 62034123130 September 1990
TABLE OF CONTENTS
Page
SECTION 1.0 SCOPE ................................. 1-1
1.1 Identification ........................ 1-11.2 Functional Summary ................... 1-1
SECTION 2.0 DOCUMENTS ............................ 2-1
2.1 Reference Documents .................. 2-12.2 Terms and Abbreviations .............. 2-1
SECTION 3.0 REQUIREMENTS ......................... 3-1
3.1 Structural Description ............... 3-13.2 Functional Flow ....................... 3-23.3 Interfaces ............................ 3-23.3.1 Inputs/Outputs ..................... 3-23.4 Program Interrupts ................... 3-33.5 Timing and Sequencing Description .. 3-33.6 Special Control Features ............. 3-33.7 Storage Allocation ................... 3-33.7.1 Database Definition ................ 3-33.7.1.1 File Description ................. 3-43.7.1.2 Table Description ................ 3-43.7.1.3 Item Description ................. 3-43.8 Object Code Creation ................. 3-43.9 Adaptation Data ...................... 3-43.10 Detail Design Description ............ 3-53.10.1 Where Include File Used List ....... 3-53.10.2 Where External Routine Used List ... 3-143.10.3 Main Program Parts List ............ 3-253.10.4 Module Documentation ............... 3-383.10.5 Include File Descriptions .......... 3-1053.10.6 Hierarchy Chart .................... 3-1253.11 Program Listings Comments ............ 3-214
SECTION 4.0 QUALITY ASSURANCE PROVISIONS ......... 4-1
4.1 Introduction and Definitions ......... 4-14.2 Computer Programming Test and
Evaluation ......................... 4-1
iv
![Page 8: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/8.jpg)
PS 62034123130 September 1990
* SECTION 1
SCOPE
1.1 Identification
This specifidatkon establishes the design of Function PRE4,##Transform ES/CS", ghe of the major functions of theConfiguration Item "Precompiler" to be built and formallyaccepted by the ICAM program Office. This CI constitutes one ofthe subsystems of the Common Data Model Processor (CDMP).
1.2 4Iunctional summaryvThe purpose of this Computer Program Configuration Item
(CPCI) is to convert an NDML or SQL request, expressed in an externalschema, and to terminate one or more NDML or SQL requests expressed inconceptual schema terms.
The following functions will be performed by this CPCI:
i) Translate each user view into the corresponding entityclasses and each data item into the correspondingattribute use classj
2) Identify the relational join operations needed toconstruct each user view table, ,
3) Identify the integrity tests that will be employed witheach NDML or SQL update request.
Acc,--Jon Fe2
NTIS C ?: 'J
N Is
-, t, :.
A -il t eH 1I<1-1
![Page 9: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/9.jpg)
PS 620341231
30 September 1990
SECTION 2
DOCUMENTS
2.1 Reference Documents
1. ICAM Documentation Standards: IDS15012000A, 28 December1981.
2. D. Appleton Co., CDM Administrators Manual;UM620141000, March, 1984.
3. D. Appleton Co., CDMI-IDEF, Model of the Common DataModel; CCS620141000, 15 May, 1985.
4. D. Appleton Co., Computer Program DevelopmentSpecification (DS) for ICAM Integrated Support System(IISS) Configuration Item: NDML Precompiler;DS620141200, October, 1984.
5. D. Appleton Co., Embedded NDML Programmer's ReferenceManual; PRM620141200, March, 1985.
6. Softech, Inc., NTM Programmer's Guide; UM620140001,July, 1984.
7. Control Data Corp., Computer Program DevelopmentSpecification (DS) for ICAM Integrated Support System(IISS) Configuration item: NDDL Command Processor:DS620141100, June 1985.
2.2 Terms and Abbreviations
Attribute Use Class: (AUC)
Conceptual Schema: (CS)
Common Data Model Processor: (CDMP)
Common Data Model: (CDM) Describes common data applicationprocess formats, form definitions, etc, of the IISS and includesconceptual schema, external, internal schemas, and schematransformation operators.
Data Field: (DF) An element of data in the externalschema. It is by this name that an NDML programmer referencedata.
Database Management System: (DBMS)
Distributed Request Supervisor: (DRS) This IISS CDMsubsystem configuration item controls the execution ofdistributed NDML queries and non distributed updates.
Domain: A logical definition of legal attribute classvalues.
2-1
![Page 10: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/10.jpg)
PS 62034123130 September 1990
Domain Constraint: Predicate that applies to a single
domain.
External Schema: (ES)
Forms: Structured views which may be imposed on windows orother forms. A form is composed of fields where each field is aform, item, or window.
Forms Processor: (FP) A set of callable execution timeroutines available to an application program for formprocessing.
Internal Schema: (IS)
Integrated Information Support System: (IISS) A testcomputing environment used to investigate, demonstrate and testthe concepts of information management and informationintegration in the context of Aerospace Manufacturing. The IISSaddresses the problems of integration of data resident onheterogeneous databases supported by heterogeneous computersinterconnected via a local Area Network.
Mapping: The correspondence of independent objects in twoschemas: ES to CS or CS to IS.
Network Transaction Manager: (NTM) Performs thecoordination, communication and housekeeping functions requiredto integrate the application processes and system servicesresident on the various hosts into a cohesive system.
Neutral Data Manipulation Languaqe: (NDML) A languagedeveloped by the IISS project to provide uniform access tocommc- data, regardless of database manager or distributioncriteria. It provides distributed retrieved and single nodeupdates.
ORACLE: Relational DBMS based on the SQL (Structured QueryLanguage, a product of ORACLE Corp, Menlo Park, CA). The CDM isan ORACLE database.
Parcel: A sequential file containing sections source codeof the input application program.
Request Processor: (RP) A COBOL program that will satisfya retrieval or update NDML subtransaction against a particularDatabase Management System.
User Interface: (UI) Controls the user's terminal andinterfaces with the rest of the system.
Virtual Terminal Interface: (VTI) Performs the interfacingbetween different terminals and the UI. This is done bydefining a specific set of terminal features and protocols whichmust be supported by UI software which constitutes the VirtualTerminal Definition. Specific terminals are then mapped againstthe Virtual Terminal software by specific software moduleswritten for each type of real terminal supported.
2-2
![Page 11: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/11.jpg)
PS 62034123130 September 1990
SECTION 3
REQUIREMENTS
3.1 Structural Description
A graphic portrayal of this CPCI is included in Section3.10. This chart shows the hierarchical relationship of eachmodule making up this CPCI.
This CPCI uses a number of lower level modules to handle
specific operations such as:
1. Verifying the user view (CDVIEW).
2. Verifying user data items (CDEMD).
3. Determining all data items in a view (CDEMDA).
4. Match view names with view abbreviations (CDABVW).
5. Determine if a partial entity class was inserted(CDPTEC).
6. Determine if a data item is mapped to conceptual schema(CDPDI).
7. Look up meta data for a conceptual attribute (CDCMD).
8. Determine if a view maps to multiple entities (CDNNEC).
9. Develop type 1 integrity test (CDINEC, CDIRIT).
10. Develop key uniqueness integrity test (CDKYUQ).
11. Check for modification of a partial inherited key class(CDMPIK).
12. Develop type 2 integrity test (CD2RIT).
13. Add rows to the CSACTIONLIST (CDACAL).
14. Add a row to the CS ACTION LIST and CSQUALITYLIST fora type I integrity test (CDACAQ).
15. Add a row to the TEMPXFORMLIST (CDATXL).
16. Retrieve a tag name (CDGTN).
17. Retrieve type 2 qualifications for a view (CDG7VW).
18. Verify join to target user view for delete and modify (CDJUV).
19. Build ES/CS Action List entries (CDMQAL).
20. Populate Boolean List (CDPBL).
3-1
![Page 12: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/12.jpg)
PS 62034123130 September 1990
21. Transform ES schema to CS (CDPRE4).
22. Obtain relation class number for outer join (CDRCNR).
23. Get the relation class and owner tag of an inheritedattribute (CDRCTG).
24. Retrieve all tags to which a view maps (CDTGVW).
25. Update a row of the TEMPXFORMLIST (CDUTXL).
26. Verify a numeric value (CDVNV).
27. Verify that a TEMPAUC is not a key class member (CDVT'K).
3.2 Functional Flow
This CPCI implements the logic defined in the DevelopmentSpecification for this CPCI. Details of inputs/outputs andrelationships between modules are to be found in Section 3.10.
This CPCI has been designated to operate in a batch orinteractive mode. It must use the ORACLE DBMS installed on a DEC VAXcomputer.
3.3 Interfaces
The following diagram depicts the interface of PRE4 withother CPCI's in the system.
----------------------------- PRE2 I
I PS41212
+ .... ---- +- ----.- -.... -
PRE3 PRE4PS41213 I
------------------
±PRE 5PS41232
3.3.1 Inputs/Outputs
The following table depicts the inputs and outputs of thisCPIC. A detail description for each item can be found in the DSfor this CPCI.
3-2
![Page 13: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/13.jpg)
PS 62034123130 September 1990
INPUT OUTPUT
ES Qualify List Return StatusES Action ListCS Qualify ListUser View Abbreviation ListCS Action ListParcel 1 File PointerParcel 2 File PointerParcel 3 File PointerParcel 4 File PointerError File PointerHor. of the precompilerHoE the AP is to run onSou. e LanguageCode generator tableUser Module IdentificationLog., Al Unit of Work NameNDML CounterBoolean ListResult Field TableJQG Attribute Pair ListBlock StackNDML StackFirst Inner SelectFortran Variable TableSubroutine LanguageEmbedded LanguageCursor TableWhenever Table
3.4 Program Interrupts
Not applicable to this CPCI.
3.5 Timing and Sequencing Description
This CPCI is called for each NDML or SQL statement parsed by PRE3and identified to be semantically correct by PRE2. Thus, PRE4may execute many times in a precompiler run. PRE 4 in turncalls PRE5 for each conceptual request. A conceptual request iseither the original user NDML or SQL request or referential integritytests, which are implemented as a conceptual schema retrievals.
3.6 Special Control Features
Not applicable to this CPCI.
3.7 Storage Allocation
3.7.1 Database Definition
The database used by this CPCI is the Common Data Model(CDM) database. This model is defined by the CDM1, the IDEF-1model of the CDM, Reference Document Number 3.
3-3
![Page 14: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/14.jpg)
PS 62034123130 September 1990
3.7.1.1 File Description
No permanent files have been defined for this CPCI. It mayuse temporary scratch files for such things as generated programsource code or temporary query results.
3.7.1.2 Table Description
All tables used by this CPCI have been defined by theDevelopment Specification for this CPCI.
3.7.1.3 Item Description
Not applicable to this CPCI.
3.8 Object Code Creation
The object code for this CPCI will be created by the systemintegration test team by using defined IISS SoftwareConfiguration Management procedures. This CPCI will use theCOBOL language compilers.
3.9 Adaptation Data
This CPCI has been coded using ANSI COBOL language. Theintent was to provide a transportable system. Any systemenvironment supporting this language, a virtual memorymanagement scheme, the ORACLE Database Management System shouldbe able to support this CPCI. Every possible attempt has madebeen to localize and identify any machine or environment dependentmodules through the original design of the IISS and application ofConfiguration Management Procedures.
3-4
![Page 15: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/15.jpg)
PS 62034123130 September 1990
3.10 Details Design Description
The following sections have been computer generated forthis CPCI.
3.10.1 Where Include File Used List
The following lists each include file in thedocumentation group and all the modules documented in thisspecification which include them. The purpose of eachmodule is listed as well.
3-5
![Page 16: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/16.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-include-file-used List
Include ModuleFile Name
ERRCDMCD1RITCD2RITCDACALCDACAQCDATXLCDCMDCDEMDCDEMDACDGTNCDGTVWCDINECCDKYUQCDMPI KCDMQALCDNNECCDPBLCDPDICDPRE4CDPTECCDRCNRCDRCTGCDTGVWCDVIEW
ERRFSCDVTGK
CDlRITCD2RITCDACAQCDCMDCDEMD
3-6
![Page 17: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/17.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-include-file-used List
Include ModuleFile Name
---- -- D- ---
CDGTVWCDINECCDKYUQCDMPIKCDMNECCDPRE4CDPTECCDVIEWCDVTGK
EODTGCElRICD2RITCDCMDTCDEMDCDEMDACDGTNACDGTVWCDINECCDKYUQ
CDMPI KCDNNECCDPDICDPRE4CDPTECCDRCNRCDRCTGCDTGVWCDVIEWCDVTGK
TXLIST
3-7
![Page 18: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/18.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-include-file-used List
Include ModuleFile Name
CDlRITCDACALCDACAQCDATXLCDINECCDKYUQCDMPI KCDPRE4CDPTECCDTGVWCDUTXLCDVTGK
ESALCDlRITCD2RITCDACALCDACAQCDEMDACDINECCDKYUQCDMQALCDNN-r-CCDPRE4CDPTECCDVTGK
ESQUALCD1RITCD2RITCDACAQCDINECCDJUV
3-8
![Page 19: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/19.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-include-file-used List
Include ModuleFile Name
CDKYUQCDMQALCDPBLCDPRE4
UVABBRCD1RITCD2RITCDABVWCDACAQCDGTVWCDINECCDJUVCDKYUQCDPRE4
CGTABLECD1RITCD2RITCDACAQCDINECCDKYUQCDPRE4
APLCD1RITCD2RITCDACAQCDINECCDKYUQCDPRE4
RFTABLECDlRITCD2RIT
3-9
![Page 20: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/20.jpg)
PS 62034123130 September 1990
DOCGRQUP PS41231 Where-include-file-used List
Include ModuleFile Name
CDACAQCDINECCDKYUQCDPRE4
BLSTACKCD1RITCD2RITCDACAQCDINECCDKYEJQCDPRE4
FORVARCDlRITCD2RITCDACAQCDINECCDKYUQCDPRE4
CSALCD1RITCD2RITCDACALCDACAQCDINECCDKYUQCDMQALCDPBLCDPRE4
CSQUALCDlRITCD2RIT
3-10
![Page 21: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/21.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-include-file-used List
Include ModuleFile Name
CDACAQCDGTVWCDINECCDKYUQCDMQALCDPBLCDPRE4
CURTABCD1RITCD2RITCDACAQCDINECCDKYUQCDPRE4
WlE NTA BCDIRITCD2RITCDACAQCDINECCDKYUQCDPRE4
ERRPROCDlRITCD2RITCDACALCDACAQCDATXLCDCMDCDEMDCDEMDACDGTN
3-11
![Page 22: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/22.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-include-file-used List
Include ModuleFile Name
- - - - - - -- - - -
CDGTVWCDINECCDKYUQCDMPI KCDMQALCDNNECCDPBLCDPDICDPRE4CDPTECCDRCNRCDRCTGCDTGVWCDVI EWCDVTGK
BOOLSTCD2RITCDACAQCDGTVWCDKYUQCDPBLCDPRE4
NDMLSTKCDEMDACDPRE4
CHKCDMCDMQALCDPBL
CSQ VARCDPRE4
DELCAT
3-12
![Page 23: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/23.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-include-file-used List
Include ModuleFile Name
CDPRE4TYP2TB
CDPRE4TJLIST
CDPRE4
3-13
![Page 24: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/24.jpg)
PS 62034123130 September 1990
3.10.2 Where External Routine Used List
The following lists eazh external function or routinein the documentation group and all the documented moduleswhich call it. The purpose of each module is listed aswell.
3-14
![Page 25: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/25.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-external-routine-used List
System ModuleModule Name
SQ LSCACDlRITCD2RITCDCMDCDEMDCDEMDACDGTNCDGTVWCDINECCDKYUQCDMPI KCDNNECCDPDICDPRE4CDPTECCDRCNRCDRCTGCDTGVWCDVIEWCDVTGK
SQLBS1CDlRITCD2RITCDCMDCDEMDCDEMDACDGTNCDGTVWCDINECCDKYUQCDMPIK
3-15
![Page 26: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/26.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-external-routine-used List
System Module
Module Name
CDNNECCDPDICDPRE4CDPTE CCDRCNRCDRCTGCDTGVWCDVIEWCDVTGK
SQLSCHCDlRITCD2RITCDCMDCDEMDCDEMDACDGTNCDGTVWCDINECCDKYUQCDMPIKCDNNECCDPDICDPRE4CDPTECCDRCNRCDRCTGCDTGVWCDVI EWCDVTGK
SQLS CCCDlRIT
3-16
![Page 27: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/27.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-external-routine-used List
System ModuleModule Name
CD2RITCDCMDCDEMDCDEMDACDGTNCDGTVWCDINECCDKYUQCDMPIKCDNNECCDPDICDPRE4CDPTECCDRCNRCDRCTGCDTGVWCDVIEWCDVTGK
S QLT FLCDlRITCDCMDCDEMDCDGTNCDGTVWCDPDICDPRE4CDRCN~RCDRCTGCDVI EWCDVTGK
SQLOPN
3-17
![Page 28: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/28.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-external-routine-used Lirt
System ModuleModule Name
CDlRITCDCMDCDEMDCDGTNCDGTVWCDPDICDPRE4CDRCNRCDRCTGCDVIEWCDVTGK
SQ LOS QCDlRITCD2RITCDCMDCDEMDCDEMDACDGTNCDGTVWCDINECCDKYUQCOMPI KCDNNECCDPDICDPFE 4CDPTECCDRCNRCDRCTGCDTGVWCDVIEWCDVTGK
3-18
![Page 29: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/29.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-external-routine-used List
System ModuleModule Name
SQLADRCD1RITCD2RITCDCMDCDEMDCDEMDACDGTNCDGTVWCDINECCDKYUQCDMPI KCDNNECCDPDICDPRE4CDPTECCDRCNRCDRCTGCDTGVWCDVIEWCDVTGK
SQ LAB 1CD1RITCD2RITCDCMDCDEMDCDEMDACDGTNCDGTVWCDINECCDKYUQCDMPI K
3-19
![Page 30: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/30.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-external-routine-used List
System ModuleModule Name
CDNNECCDPDICDPRE4CDPTECCDRCNRCDRCTGCDTGVWCDVIEWCDVTGK
SQLEXECD1RITCD2RITCDCMDCDEMDCDEMDACDGTNCDGTVWCDINECCDKYUQCDMPIKCDNNECCDPDICDPRE4CDPTECCDRCNRCDRCTGCDTGVWCDVIEWCDVTGK
SQLAD 1CD1RIT
3-20
![Page 31: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/31.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-external-routine-used List
System ModuleModule Name
CD2RITCDCMDCDEMDCDEMDACDGTNCDGTVWCDINECCDKYUQCDMPIKCDNNECCDPDICDPRE4CDPTECCDRCNRCDRCTGCDTGVWCDVIEWCDVTGK
SQLFCHCDlRITCD2RITCDCMDCDEMDCDEMDACDGTNCDGTVWCDINECCDKYUQCDMPIKCDNNECCDPDI
3-21
![Page 32: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/32.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-external-routine-used List
System ModuleModule Name
CDPRE4CDPTECCDRCNRCDRCTGCDTGVWCDVIEWCDVTGK
ERRPROCD1RITCD2RITCDACALCDACAQCDATXLCDCMDCDEMDCDEMDACDGTNCDGTVWCDINECCDKYUQCDMPIKCDMQALCDNNECCDPBLCDPDICDPRE4CD PTE CCDRCNRCDRCTGCDTGVWCDVIEW
3-22
![Page 33: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/33.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-external-routine-used List
System ModuleModule Name
CDVTGKSQLTOC
CD2RITCDEMDACDGTVWCDINECCDKYUQCDMPIKCDNNECCDPRE4CDPTECCDTGVW
SQLCLSCD2RITCDEMDACDGTVWCDINECCDKYUQCDMPI KCDNNECCDPTECCDTGVW
CDPRE 5CD2RITCDACAQCDKYUQCDPRE4
CDCATCDACAL
RPTERRCDEMD
3-23
![Page 34: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/34.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Where-external-routine-used List
System ModuleModule Name
CDGTNCDJUVCDMPI KCDNNECCDPRE4CDPTECCDVI EWCDVNVCDVTGK
CDIDIUCDPRE4
CD2NECCDPRE4
CDCRITCDPRE4
CDAUCCDPRE4
CDERCCDPRE4
CDASELCDPRE4
CDELISCDPRE4
CD2SELCDPRE 4
CDZ DELCDPRE4
3-24
![Page 35: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/35.jpg)
PS 62034123130 September 1990
3.10.3 Main Program Parts List
The following lists each Main Program in thedocumentation group and all the modules which are calledeither by that module itself or by any of the documentedmodules which it calls. It is possible for a non-mainmodule to be listed more that once if it is called bymultiple modules. The called modules, in this case known asprogram parts, are marked as to whether they are documentedhere. If so, the phrase "well-defined module" appears bythe module name, if not it is an "external "routine". ThePurpose of the Main Program module is listed as well.
3-25
![Page 36: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/36.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Main Program Parts List
Main Pgm Module ModuleName Name Type
CDIRITSQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routineSQLTFL External routineSQLOPN External routineSQLOSQ External routineSQLADR External routineSQLAB1 External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineCDACAQ Well-defined moduleERRPRO External routine
CD2RITSQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routineSQLOSQ External routineSQLADR External routineSQLAB1 External routineSQLEXE External routineSQLADI External routineSQLFCH External routineERRPRO External routineSQLTOC External routineSQLCLS External routineCDPRE5 External routineCDCMD Well-defined module
3-26
![Page 37: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/37.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Main Program Parts List
Main Pgm Module ModuleName Name Type
CDMQAL Well-defined moduleCDPBL Well-defined module
CDABVWCDACAL
ERRPRO External routineCDCAT External routine
CDACAQERRPRO External routineCDPRE5 External routineCDCMD Well-defined moduleCDMQAL Well-defined moduleCDPBL Well-defined module
CDATXLERRPRO External routine
CDCMDSQLSCA External routineSQLBSI External routineSQLSCH External routineSQLSCC External routineSQLTFL External routineSQLOPN External routineSQLOSQ External routineSQLADR External routineSQLAB1 External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineERRPRO External routine
CDEMDSQLSCA External routineSQLBS1 External routine
3
3-27
![Page 38: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/38.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Main Program Parts List
Main Pgm Module ModuleName Name Type
SQLSCH External routineSQLSCC External routineSQLTFL External routineSQLOPN External routineSQLOSQ External routineSQLADR External routineSQLABI External routineSQLEXE External routineSQLADI External routineSQLFCH External routine
ERRPRO External routineRPTERR External routine
CDEMDASQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routineSQLOSQ External routineSQLADR External routineSQLAB1 External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineERRPRO External routineSQLTOC External routineSQLCLS External routine
CDGTNSQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routine
3-28
![Page 39: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/39.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Main Program Parts List
Main Pgm Module ModuleName Name Type
-- - --- - ----- --- ---
SQLTFL External routineSQLOPN External routineSQLOSQ External routineSQLADR External routineSQLAB1 External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineERRPRO External routineRPTERR External routine
CDGTVWSQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routineSQLTFL External routineSQLOPN External routineSQLOSQ External routineSQLADR External routineSQLAB1 External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineERRPRO External routineSQLTOC External routineSQLCLS External routineCDCMD External routine
CDINECSQLSCA External routineSQLBS1 External routineSQLSCH External routine
3-29
![Page 40: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/40.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Main Program Parts List
Main Pgm Module ModuleName Name Type
SQ-- CC External routineSQLSCC External routineSQLOSQ External routineSQLADR External routineSQLAB1 External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineCDACAQ External routineERRPRO External routineSQLTOC External routineSQLCLS External routine
CDJUVRPTERR External routine
CDKYUQSQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routineSQLOSQ External routineSQLADR External routineSQLAB1 External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineERRPRO External routineSQLTOC External routineSQLCLS External routineCDPRE5 External routineCDCMD External routineCDMQAL Well-defined moduleCDPBL Well-defined module
3-30
![Page 41: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/41.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Main Program Parts List
Main Pgm Module ModuleName Name Type
CDMPIKSQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routineSQLOSQ External routineSQLADR External routineSQLAB1 External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineERRPRO External routineSQLTOC External routineSQLCLS External routineRPTERR External routineCDGTN External routine
CDMQALERRPRO External routine
CDNNECSQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routineSQLOSQ External routineSQLADR External routineSQLAB1 External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineERRPRO External routineSQLTOC External routine
3-31
![Page 42: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/42.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Main Program Parts List
Main Pgm Module ModuleName Name Type
SQLCLS External routineRPTERR External routine
CDPBLERRPRO External routine
CDPDISQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routineSQLTFL External routineSQLOPN External routineSQLOSQ External routineSQLADR External routineSQLAB1 External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineERRPRO External routine
CDPRE4SQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routineSQLTFL External routineSQLOPN External routineSQLOSQ External routineSQLADR External routineSQLAB1 External routineSQLEXE External routineSQLADI External routineSQLFCH External routine
3-32
![Page 43: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/43.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Main Program Parts List
Main Pgm Module ModuleName Name Type
ERRPRO External routineSQLTOC External routineCDPRE5 External routineCDCMD External routineCDMQAL External routineCDPBL External routineRPTERR External routineCDGTVW External routineCDIDIU External routineCDVIEW Well-defined moduleCDABVW External routineCDEMDA External routineCDEMD External routineCDPDI External routineCDPTEC Well-defined moduleCDINEC External routineCD2NEC External routineCDKYUQ External routineCDACAL External routineCDNNEC External routineCDATXL External routineCDRCTG Well-defined moduleCDUTXL Well-defined moduleCDVTGK Well-defined moduleCDMPIK External routineCDIRIT External routineCDCRIT External routineCDJUV External routineCDAUC External routineCDTGVW Well-defined moduleCD2RIT External routine
3-33
![Page 44: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/44.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Main Program Parts List
Main Pgim Module ModuleName Name Type
CDERC External routineCDASEL External routineCDELIS External routineCD2SEL External routineCDZDEL External routineCDVNV Well-defined moduleCDRCNR Well-defined module
CDPTECSQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routineSQLOSQ External routineSQLADR External routineSQLABI External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineERRPRO External routineSQLTOC External routineSQLCLS External routineRPTERR External routine
CDRCNRSQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routineSQLTFL External routineSQLOPN External routineSQLOSQ External routineSQLADR External routine
3-34
![Page 45: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/45.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Main Program Parts List
Main Pgm Module ModuleName Name Type
SQLABl External routineSQLEXE External routineSQLADI External routineSQLFCH External routineERRPRO External routine
CDRCTGSQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routineSQLTFL External routineSQLOPN External routineSQLOSQ External routineSQLADR External routineSQLAB1 External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineERRPRO External routine
CDTGVWSQLSCA External routineSQLBSI External routineSQLSCH External routineSQLSCC External routineSQLOSQ External routineSQLADR External routineSQLABI External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineERRPRO External routine
3-35
![Page 46: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/46.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Main Program Parts List
Main Pgm Module ModuleName Name Type
SQLTOC External routineSQLCLS External routineCDCMD External routineCDATXL External routine
CDUTXLCDVIEW
SQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routineSQLTFL External routineSQLOPN External routineSQLOSQ External routineSQLADR External routineSQLAB1 External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineERRPRO External routineRPTERR External routine
CDVNVRPTERR External routine
CDVTGKSQLSCA External routineSQLBS1 External routineSQLSCH External routineSQLSCC External routineSQLTFL External routineSQLOPN External routineSQLOSQ External routineSQLADR External routine
3-36
![Page 47: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/47.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Main Program Parts List
Main Pgm Module ModuleName Name Type
SQLAB1 External routineSQLEXE External routineSQLAD1 External routineSQLFCH External routineERRPRO External routineRPTERR External routine
3-37
![Page 48: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/48.jpg)
PS 62034123130 September 1990
3.10.4 Module Documentation
The following documentation describes informationwhich is specific to each individual module in thedocumentation group being documented in this specitication.It provides a compact way of getting information that wouldbe otherwise buried within each module's source code.
The specific items in this module documentation have the
following meanings:
NAME: Name of program Module.
PURPOSE: Purpose of Module as detailed in thesource code.
LANGUAGE: Programming language source code iswritten in.The choices are:
VAX-11 FORTRANC (I/S-I Workbench 'C')VAX-11 COBOL
MODULE TYPE: Whether a Program, Subroutine, orFunction.
SOURCE FILE: Name of Source File from filespecification.
SOURCE FILE TYPE: Source File Extension from filespecification.
HOST: Whether this is a host-dependentroutine (VAX or IBM) or blank ifhost-independent.
SUBSYSTEM: IISS sub-system this file resides in.
SUBDIRECTORY: Sub-directory of that subsystem inwhich this file resides.
DOCUMENTATION GROUP: Name of documentation group of whichthis source file is a member.
DESCRIPTION: A description of the module as otainedfrom the source code.
ARGUMENTS: The arguments with which this routineis called if it is a Subroutine or aFunction.
INCLUDE FILES: A list of all the files that areincluded into this module as well astheir purposes.
ROUTINES CALLED: Subroutines or Functions, eitherdocumented or external, called bythis module, if any.
3-38
![Page 49: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/49.jpg)
PS 62034123130 September 1990
CALLED DIRECTLY BY: The documented routines which callthis module, if any.
USED IN MAIN PROGRAM(S): The documented Main Programs whichcontain this module in their partslist according to the list in section3.10.3.
The Module Documentation is arranged alphabetically accordingto Module iiame.
3-39
![Page 50: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/50.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDlRITPURPOSE: PERFORMS SEARCH OF LINKRELATION TO EXTRACT IND ECNO
FOR TYPE 1 R.LANGUAGE: VAX-Il COBOLSOURCE FILE: CDlRITSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
PERFORM SQL SEARCH OF LINK RELATION TABLE TO EXTRACT THEINDEPENDENT EC NO WHICH CORRESPONDS TO EACH TEMP-RC-NO. CALLCDACAQ TO FILL ROWS OF CS-ACTION-LIST AND CS-QUALIFY-LISTAND GENERATE A TYPE 1 REFERENTIAL INTEGRITY TEST.MODIFIED FOR EMBEDDED SQL -- 19 MAY 1986ADD LUW-NAME AS PASS-THROUGH PARAMETER -- 23 MAY 1986CHANGED TO DO LOOKUPS INTO LINK RELATION -- 1 MAY 1989FOR EACH NON-ZERO RELATION CLASS, OBTAIN ALL INDEPENDENTENTITY CLASS NUMBERS. FOR EACH UNIQUE INDEPENDENTENTITY CLASS NUMBER, CALL CDACAQ TO EVENTUALLYGENERATE A TYPE 1 REFERENTIAL INTEGRITY TEST.
ARGUMENTS:
MODEL-NO DSPLY[S9(4) ]TEMP-XFORM-LIST RECRDES-ACTION-LIST RECRDES-QUALIFY-LIST RECRDUV-ABBR-LIST RECRDCODE-GENERATOR-TABLE RECRD
3-40
![Page 51: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/51.jpg)
PS 62034123130 September 1990
FCB-1 DSPLY[S9(9)]FCB-2 DSPLY[S9(9)]FCB-3 DSPLYCS9(9)]FCB-4 DSPLY[S9(9)]MY-HOST DSPLY [XXX]TARGET-HOST DSPLY [XXX]SOURCE-LANGUAGE DSPLY[X(10)]FCB-E DSPLY[S9 (9)]NDML-COUNTER DSPLY[9(6)]CS-ACTION-LIST RECRDCS-QUALIFY-LIST RECRDLUW-NAME DSPLY[X(30)]ERROR-STATUS DSPLY [9]RFT RECRDJQG-ATTRIBUTE-PAIR-LIST RECRDBLOCK-STACK RECRDFIRST-INNER-SELECT DSPLY [9]FORTRAN-VARIABLE-TABLE RECRDSUB-LANG DSPLY[X(10)]EMBEDDED-LANGUAGE DSPLY[X(10)]CURSOR-TABLE RECRDWHENEVER-TABLERET-STATUS DSPLY[X(5)]
INCLUDE FILES:
ERRCDMERRFSEODTXLISTESALESQUALUVABBRCGTABLEAPLRFTABLEBLSTACKFORVAR
3-41
![Page 52: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/52.jpg)
PS 62034123130 September 1990
CSALCSQUALCURTABWHENTABERRPRO
ROUTINES CALLED:- - - - - - - - - - - - -
SQLSCASQLBS1SQLSCHSQLS CCS QLTFLSQLOPNS QLOS QSQLADRSQ LAB 1SQLEXESQ LAD 1SQLFCHCDACAQERRPRO
3-42
![Page 53: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/53.jpg)
PS 6 2 0 3 4 123i30 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CD2RITPURPOSE: SETS UP TYPE 2 REFERENTIAL INTEGRITY CHECKLANGUAGE: VAX-Il COBOLSOURCE FILE: CD2RITSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
FILL IN CS ACTION LIST AND CS-QUALIFY LIST FOR TYPE 2 RITEST. ON EXIT, RESET CSQ-USED TO ITS VALUE ON INPUT.MODIFY FOR EMBEDDED SQL -- 23 MAY 1986CHANGE NDML-COUNTER AND NDML-HOLD TO PIC 9(6) -- 23 MAY 1986CHANGE VH-COUNTER TO PIC X(6) -- 23 MAY 1986DELETE CE-WORK-LIST AND USER-ERROR-COUNT -- 23 MAY 1986ADD BOOLEAN-LIST AND LUW-NAME -- 23 MAY 1986ADD CDMQAL AND CDPBL CALLS -- 23 MAY 1986CHANGE CDPRE6 CALLS TO CDPRE5 CALLS -- 23 MAY 1986MOVE U TO CSQ-SOURCE (CS-QUALIFY) -- 4 MAR 1987CHECK FOR "V" IN CSQ-SOURCE (CS-QUALIFY) BEFOREMOVING COUNTER TO CSQ-VARIABLE -- 23 JUN 1987FOR EACH INDEPENDENT ENTITY OF THE ENTITY TO BEDELETED, GENERATE A TYPE 2 REFERENTIAL INTEGRITYTEST BY POPULATING THE CS-ACTION LIST AND ADDING TOTHE CS-QUALIFY AND BOOLEAN LISTS.
ARGUMENTS:
MODEL-NO DSPLY[S9(4)]IND-EC-NO DSPLY[$9 (4)]
3-43
![Page 54: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/54.jpg)
PS 62034123130 September 1990
ES-ACTION-LIST RECRDES-QUALIFY-LIST RECRDUV-ABBR-LIST RECRDCODE-GENERATOR-TABLE RECRDFOB-i DSPLY[S9 (9)]FCB-2 DSPLY[S9(9)]FCB-3 DSPLY[S9(9)]FCB-4 DSPLY[S9(9)]MY-HOST DSPLY [XXX]TARGET-HOST DSPLY [XXX]SOURCE-LANGUAGE DSPLY[X(10)]FCB-E DSPLY[S9(9)]NDML-COUNTER DSPLY[9(6)]CS-ACTION-LIST RECRDCS-QUALIFY-LIST RECRDBOOLEAN-LIST RECRDLUW-NAME DSPLY[X(30)]ERROR-STATUS DSPLY [9]RFT RECRDJQG-ATTRIBUTE-PAIR-LIST RECRDBLOCK-STACK RECRDFIRST-INNER-SELECT DSPLY [9]FORTRAN-VARIABLE-TABLE RECRDSUB-LANG DSPLY[X(10)]EMBEDDED-LANGUAGE DSPLY[X(10)]CURSOR-TABLE RECRDWHENEVER-TABLERET-STATUS DSPLY[X(5)]
INCLUDE FILES:
ERRCDMERRFSEODESALESQUALUVABBRCGTABLE
3-44
![Page 55: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/55.jpg)
PS 62034123130 Septemnber 1990
APLRFTABLEBLS TACKFORVARCSALCSQUALBOOLS TCURTABWHENTABERRPRO
ROUTINES CALLED:
S QLS CASQLBS1SQLSCHSQLS CCSQ LTOCS QLOS QS QLADRS QLAB 1SQLEXESQ LCLSS QLAD 1SQLFCHCDPRE 5CDCMDCDMQALCDPBLERRPRO
3-45
![Page 56: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/56.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDABVWPURPOSE: CDABVW-GET THE VIEW NUMBER GIVEN THE USER ENTERED
ABBREVIATIONLANGUAGE: VAX-lI COBOLSOURCE FILE: CDABVWSOURCE FILE TYPE: COBHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
SCAN THE UV-ABBR-LIST SEARCHING FOR A UVABBRMATCHING THE INPUT ARGUMENT, ABBREV. IF FOUND, RETURNTHE CORRESPONDING VIEW NUMBER AND UV-INDEX, OTHERWISE ZERO.
SCAN THE UV-ABBR-LIST FOR A UV-ABBR MATCHING ABBREV.RETURN CORRESPONDING UV-NO AND INDEX.
ARGUMENTS:
ABBREV DSPLY(XX]UV-ABBR-LIST RECRDVIEW-NO DSPLY[S9 (4)]UV-PTR DSPLY[99]
INCLUDE FILES:
UVABBR
3-46
![Page 57: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/57.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDACALPURPOSE: ADD ROWS TO THE CS-ACTION-LISTLANGUAGE: VAX-I COBOLSOURCE FILE: CDACALSOURCE FILE TYPE: COBHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
FILL THE CS ACTION LIST FROM THE TEMP TRANSFORM LISTINITIALIZE CS-DELETE-FLAG -- 16 MAY 1986INITIALIZE CS-SOURCE -- 16 MAY 1986DETERMINE IF ENTITY IS GENERIC AND SET NEW FLAGCS-CATEGORY-FLAG IF AUC IS THE CATEGORY DISCRIMINATOR -10 APR1989MOVE ROWS, 1 AT A TIME, FROM THE TEMP TRANSFORM LISTTO THE CS-ACTION-LIST. IF CSAL OVERFLOW, GENERATEAN ERROR MESSAGE. CHECK EC-NO TO DETERMINE IF GENERICIF SO, RETRIEVE AUC OF CATEGORY DISCRIMINATOR.
ARGUMENTS:
TEMP-XFORM-LIST RECRDCS-ACTION-LIST RECRDES-ACTION-LIST RECRDRET-STATUS DSPLY[X(5)]
INCLUDE FILES:
ERRCDM
3-47
![Page 58: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/58.jpg)
PS 62034123130 September 1990
TXLISTCSALESALERRPRO,
ROUTINES CALLED:- - - - - - - - - - - - -
CDCATERR PRO
3-48
![Page 59: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/59.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDACAQPURPOSE: ADD ROW TO CS ACTION LIST AND CS QUALIFY LIST AND
TYPE 1 RITLANGUAGE: VAX-Il COBOLSOURCE FILE: CDACAQSOURCE FILE TYPE: COBHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
FOR THE FIRST TEMP-RC-NO ENTRY WHICH MATCHES THE INPUTARGUMENT, FILL IN A CS-ACTION ENTRY AND A CS QUALIFY ENTRY.FOR EACH ADDITIONAL MATCH, FILL IN A CS QUALIFY ENTRY.ELIMINATE CSQ DUPLICATES AND CALL CDPRE6 TO GENERATE ATYPE 1 REFERENTIAL INTEGRITY TEST.ADD BOOLEAN-LIST -- 21 MAY 1986DELETE USER-ERROR-COUNT -- 21 MAY 1986CHANGE NDML-COUNTER TO PIC9(6) -- 21 MAY 1986DELETE LDA REFERENCES -- 21 MAY 1986ADD CDMQAL AND CDPBL CALLS -- 21 MAY 1986POPULATE 2 NEW CS-ACTION FIELDS(CS-SOURCE AND CS-DELETE-FLAG) -- 21 MAY 1986MODIFY CSQ DUPLICATE ELIMINATION LOGIC - 21 MAY 1986ADD LUW-NAME AS PASS-THROUGH PARAMETER -- 23 MAY 1986CHANGE CDPRE6 CALL TO CDPRE5 CALL -- 23 MAY 1986MOVE U TO CSQ-SOURCE (CS-QUALIFY) -- 5 MAR 1987CHECK FOR "V" IN CSQ-SOURCE BEFORE MOVINGCOUNTER TO CSQ-VARIABLE -- 23 JUN 87DELETED IOS-SECTION PARAMETER -- 2 MAY 1989POPULATE THE FIRST CS ACTION ROW, AND AS MANYCS QUALIFY ROWS AS THERE ARE TEMP-RC-NO'S
3-49
![Page 60: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/60.jpg)
PS 62034123130 September 1990
MATCHING THE INPUT PARAMETER RC-NO. AFTERALL ACTION AND QUALIFY TABLE ENTRIES HAVE BEENPOPULATED, MOVE ALL AUC ENTRIES IN THE QUALIFYLIST WHICH AREN'T ALREADY ON THE ACTION LIST TOTHE ACTION LIST. ALSO POPULATE THE BOOLEAN LIST.FINALLY, CALL CDPRE5 TO GENERATE THE TYPE 1REFERENTIAL INTEGRITY TEST.
ARGUMENTS:
TEMP-XFORM-LIST RECRDIND-EC-NO DSPLY[$9 (4)]RC-NO DSPLY[S9(4)]ES-ACTION-LISTES-QUALIFY-LISTUV-ABBR-LISTCODE-GENERATOR-TABLEFCB-1FCB-2FCB-3FCB-4MY-HOSTTARGET-HOSTSOURCE-LANGUAGEFCB-ENDML-COUNTERCS-ACTION-LISTCS-QUALIFY-LISTMODEL-NOLUW-NAMEERROR-STATUSRFTJQG-ATTRI BUTE-PAIR-LISTBLOCK-STACKFIRST-INNER-SELECTFORTRAN-VARIABLE-TABLESUB-LANGEMBEDDED-LANGUAGECURSOR-TABLE
3-50
![Page 61: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/61.jpg)
PS 62034123130 September 1990
WHENEVER-TABLERET-STATUS
4
INCLUDE FILES:
ERRCDM* ERRFS
BOOLSTTXLISTESALESQUALUVABBRCGTABLEBLSTACKAPLRFTABLEFORVARCSALCSQUALCURTABWHENTABERRPRO
ROUTINES CALLED:
CDPRE5CDCMDCDMQALCDPBLERRPRO
3-51
![Page 62: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/62.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDATXLPURPOSE: ADD ROW TO TEMP-XFORM-LISTLANGUAGE: VAX-lI COBOLSOURCE FILE: CDATXLSOURCE FILE TYPE: COBHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
FILL IN NEXT TEMP-XFORM LIST ENTRY WITH CORRESPONDING INPUTPARAMETERS. ADJUST ROW-USED INDICATOR TO POINT TO LAST USEDROW GUARDING AGAINST TABLE OVERFLOW.CHANGE NDML-COUNTER TO 9(6) -- 19 MAY 1986POPULATE NEXT ROW OF TEMP TRANSFORM LIST
ARGUMENTS:
EC-NO DSPLY[S9(4)]TAG-NO DSPLY[$9(4)]CS-TYPE DSPLY[X]CS-SIZE DSPLY[999]CS-ND DSPLY[99]ES-INDEX DSPLY[99]NDML-COUNTER DSPLY[9(6)]TEMP-XFORM-LIST RECRDRET-STATUS DSPLY[X(5)]
INCLUDE FILES:
3-52
![Page 63: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/63.jpg)
PS 62034123130 September 1990
ERRCDMTXLISTERRPRO
ROUTINES CALLED:
ERRPRO
3-53
![Page 64: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/64.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDCMDPURPOSE: EXTRACT CONCEPTUAL METADATA GIVEN THE TAG NUMBERLANGUAGE: VAX-I COBOLSOURCE FILE: CDCMDSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDM -
SUBDIRECTORY: NDML
DESCRIPTION:
- THIS ROUTINE WILL USE A TAG NUMBER OF AN ATTRIBUTEUSE CLASS AND ACCESS THE CDM FOR ITS CONCEPTUALTYPE, SIZE AND NUMBER OF DECIMAL DIGITS.
ROUTINE WAS MODIFIED TO USE EMBEDDED SQL 5/14/86ROUTINE WAS MODIFIED NOT TO USE ORACLEVIEW FOR RELEASE 2.3
SELECT THE PROPER DOMAIN GIVEN THE TAG NUMBER. SELECT TYPE,SIZE ANDNUMBER OF DECIAML DIGITS GIVEN THE DOMAIN.
ARGUMENTS:
MODEL-NO DSPLY[$9 (4)]TAG DSPLY[S9(4)]FCB-E DSPLY [$9 (9) ]EC-NO DSPLY[$9 (4)]CS-TYPE DSPLY[X]CS-SIZE DSPLY[999]CS-ND DSPLY[99]ERROR-STATUS DSPLY[9]RET-STATUS DSPLY[X(5)]
3-54
![Page 65: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/65.jpg)
PS 62034123130 September 1990
INCLUDE FILES:
ERRCDMER2RFSEOD
* ERRPRO
ROUTINES CALLED:
SQLSCAS QLBS 1SQLS CHSQLS CCS QLTFLSQLOPNSQ LOSQSQLADRSQLAB 1SQLEXESQLAD1SQLFCHERRPRO
3-55
![Page 66: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/66.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDEMDPURPOSE: RETRIEVE EXTERNAL METADATA AND DATA ITEM NUMBERLANGUAGE: VAX-Il COBOLSOURCE FILE: CDEMDSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
PERFORM SQL SELECT TO RETURN EXTERNAL METADATA (TYPE, SIZE,NUMBER OF DECIMALS), AND THE DATA ITEM NUMBER GIVEN THEVIEW NUMBER AND THE DATA ITEM NAME.MODIFIED FOR EMBEDDED SQL -- 5/9/86MODIFIED TO ACCEPT SOURCE-LANGUAGE PARAMETER AND CHECKFOR F, C OR I DATA TYPE IF SOURCE LANGUAGE IS FORTRAN -- 3/5/87SELECT DATA ITEM NUMBER, DATA TYPE, SIZE ANDNUMBER OF DECIMAL DIGITS FOR A PARTICULARDATA ITEM NAME WITHIN THE GIVEN VIEW. IF NOTFOUND, GENERATE AN ERROR MESSAGE.
ARGUMENTS:
VIEW-NO DSPLY[$9 (4)]DI-NAME DSPLY[X(30)]SOURCE-LANGUAGE DSPLY[X(10)]FCB-E DSPLY[$9(9)]DI-NO DSPLY[S9(4)]ES-TYPE DSPLY[X]ES-SIZE DSPLY[999]ES-ND DSPLY[99]
3-56
![Page 67: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/67.jpg)
PS 62034123130 September 1990
RET-STATUS DSPLY[X(5)]
INCLUDE FILES:
ERRCDMERRFS
* EODERRPRO
ROUTINES CALLED:
SQLSCASQLBS1SQLSCHSQLSCCSQLTF LSQLOPNS QLOSQSQLADRS QLAB12SQLEXESQLAD 1SQLFCHRPTERR.ERRPRO
3-57
![Page 68: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/68.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDEMDAPURPOSE: EXPAND ES ACTION LIST TO HOLD ALL DI NAMES FOR A
USER VIEWLANGUAGE: VAX-Il COBOLSOURCE FILE: CDEMDASOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
EXTRACT DI NAMES FOR ALL DATA ITEMS IN A USER VIEW.FOR EACH DI NAME EXTRACTED, MAKE AN ENTRY IN THEES ACTION LIST. FOR THE FIRST DI NAME EXTRACTED, EXPAND THELASTUSED ROW OF THE ES ACTION LIST. FOR EACH ADDITIONAL DI NAME,FILLIN A NEW ROW.MODIFIED FOR EMBEDDED SQL 5/5/86ADDED NEW PARAMETER NDMLSTK TO SOLVE ES-ACTION-LIST BUCWHEN DOING SELECT ALL WITH CURLY BRACKET 07/31/90EXTRACT ALL DATA ITEMS FOR THE GIVEN VIEW ANDINSERT THEM INTO THE ES-ACTION-LIST.
ARGUMENTS:
VIEW-NO DSPLY[S9(4)]ES-ACTION-LIST RECRDNDML-STACK RECRDRET-STATUS DSPLY[X(5)]
3-58
![Page 69: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/69.jpg)
PS 62034123130 September 1990
* INCLUDE FILES:
ERRCDMEODESALNDMLSTKERLRPRO
ROUTINES CALLED:
SQLSCASQLBS1SQLSCHSQLSCCSQLTOCSQ LOS QSQLADRSQ LAB 1SQ LEXESQLCLSSQ LAD 1SQLFCHERRPRO
3-59
![Page 70: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/70.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDGTNPURPOSE: RETRIEVE TAG NAME.LANGUAGE: VAX-Il COBOLSOURCE FILE: CDGTNSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
THIS ROUTINE RETRIEVES THE ENTITY CLASS NAME AND TAGNAME GIVEN A TAG NUMBER.
ARGUMENTS:
FCB-E DSPLY[$9(9)]TAG-NO DSPLY[$9(4)]EC-NO DSPLY[$9(4)]TAG-NAME DSPLY[X(30)]EC-NAME DSPLY[X(30)]RET-STATUS DSPLY[X(5) ]
INCLUDE FILES:
ERRCDMERRFSEODERRPRO
3-60
![Page 71: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/71.jpg)
PS 62034123130 September 1990
* ROUTINES CALLED:
SQLSCASQLBS1SQLS CHSQLSCCS QLTFLSQLOPNSQLOSQSQLADRSQLAB 1SQLEXES QLAD 1SQLFCHRPTERR,ERRPRO
3-61
![Page 72: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/72.jpg)
PS 620341231
30 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDGTVWPURPOSE: EXTRACT VIEW TYPE 2 FROM CDM AND POPULATE CSQ AND
BOOLEANLANGUAGE: VAX-I COBOLSOURCE FILE: CDGTVWSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
- THIS ROUTINE WILL SELECT TYPE 2'SQUALIFICATIONS FOR A SPECIFIED VIEW FROMVIEW QUALIFIY CRITERIA (CONDITION, TEXT TYPEAND TEXT). IT-POPULATES THE CS-QUALIFY ANDBOOLEAN LISTS. THIS ROUTINE IS CALLED FROMCDPRE4 FOR SELECT, MODIFY, DELETE AND QUERY-COMBINATION NDML ACTIONS.
ARGUMENTS:
MODEL-NO DSPLY[S9(4)]UV-ABBR-LIST RECRDCS-QUALIFY-LIST RECRDBOOLEAN-LIST RECRDNDML-ACTION DSPLY[X]FCB-E DSPLY[$9(9)]ERROR-STATUS DSPLY[9]RET-STATUS DSPLY[X(5)]
3-62
![Page 73: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/73.jpg)
PS 62034123130 September 1990
* INCLUDE FILES:
ERRCDMERRFSEODUVABBRCSQUALBOOLSTERRPRO
ROUTINES CALLED:
SQLSCASQLBS1SQLSCHSQLS CCS QLTOCS QLOS QSQLADRSQLAB 1SQLEXESQ LAD 1SQLFCHS QLT FLSQLOPNCDCMDSQLCLSERRPRO
3-63
![Page 74: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/74.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDINECPURPOSE: RETRIEVE IND ENT FOR DEP ENT AND PERFORM TYPE1 REF
INTEG TESTLANGUAGE: VAX-lI COBOLSOURCE FILE: CDINECSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
PERFORM SQL SEARCH OF LINKRELATION TABLE TO FIND ANY IN-DEPENDENT ENTITY CLASSES. FOR EACH FOUND, CALL CDACAQ TO SETUP TYPE 1 REFERENTIAL INTEGRITY TEST.CONVERTED TO EMBEDDED SQL -- 14 MAY 1986NDML-COUNTER MADE PIC 9(6)-- 14 MAY 1986USER-ERROR-COUNT DELETED -- 14 MAY 1986ADD LUW-NAME AS PASS THROUGH PARAMETER -- 22 MAY 1986CONVERT TO CHECK OF LINK RELATION TABLE --- 10 APR 1989PERFORM SQL SEARCH OF LINK RELATION TABLE FOR ALLINDEPENDENT ENTITIES OF TEMP-EC-NO (1). FOR EACHINDEPENDENT ENTITY FOUND, CALL CDACAQ TO GENERATEA TYPE 1 REFERENTIAL INTEGRITY TEST.
ARGUMENTS:
MODEL-NO DSPLY[$9(4)]TEMP-XFORM-LIST RECRDES-ACTION-LIST RECRDES-QUALIFY-LIST RECRDUV-ABBR-LIST RECRD
3-64
![Page 75: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/75.jpg)
PS 620341231
30 September 1990
CODE-GENERATOR-TABLE RECRDFCB-1 DSPLY[S9(9)]FCB-2 DSPLY[$9(9)]FCB-3 DSPLY[S9(9)]FCB-4 DSPLY[S9(9)]MY-HOST DSPLY [XXX]TARGET-HOST DSPLY [XXX]SOURCE-LANGUAGE DSPLY[X(10)]FCB-E DSPLY[$9(9)]NDML-COUNTER DSPLY[9(6)]CS-ACTION-LIST RECRDCS-QUALIFY-LIST RECRDLUW-NAME DSPLY[X(30)]ERROR-STATUS DSPLY [9]RFTJQG-ATTRI BUTE-PAIR-LISTBLOCK-STACKFIRST-INNER-SELECTFORTRAN-VARIABLE-TABLESUB-LANGEMBEDDED-LANGUAGECURSOR-TABLEWHENEVER-TABLERET-STATUS
INCLUDE FILES:
ERRCDMERRFSEODTXLISTESALESQUALUVABBRCGTABLECSALCSQUALRFTABLE
3-65
![Page 76: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/76.jpg)
PS 62034123130 September 1990
APLBLSTACKFORVAR.CURTABWHENTABERRPRO
ROUTINES CALLED:
SQLSCASQLBS.S QLS CHSQLS CCSQLTOCSQLOSQSQLA DRS QLAB 1SQLEXESQLC LSSQ LAD 1SQLFCHCDACAQERRPRO
3-66
![Page 77: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/77.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDJUVPURPOSE: VERIFY JOIN TO TARGET USER VIEW FOR DELETE AND MODIFYLANGUAGE: VAX-lI COBOLSOURCE FILE: CDJUVSOURCE FILE TYPE: COBHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
CDJUV ENSURES, THAT FOR A DELETE OR MODIFY WITH A USINGCLAUSE, THAT AT LEAST ONE OF THE "USING" VIEWS JOINSBACK TO THE TARGET TABLE.SEARCH BOTH RIGHT AND LEFT SIDES OF THE ESQ TRYINGTO MATCH ESQ-UV-ABBRR AND ABBRL WITH UV-ABBRR(1).IF A MATCH IF FOUND, CHECK IF THE OPPOSITE SIDECONTAINS A VIEW REFERENCE NOT EQUAL TO THE TARGETVIEW. IF NO JOINS TO THE TARGET VIEW ARE FOUND,GENERATE AN ERROR MESSAGE.
ARGUMENTS:
UV-ABBR-LISTES-QUALIFY-LISTFCB-EERROR-STATUS
INCLUDE FILES:
3-67
![Page 78: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/78.jpg)
PS 62034123130 September 1990
UVABBRESQUAL
ROUTINES CALLED:
RPTERR
3-68
![Page 79: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/79.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDKYUQPURPOSE: SET UP KEY UNIQUENESS TEST FOR AN ENTITYLANGUAGE: VAX-lI COBOLSOURCE FILE: CDKYUQSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
FILL IN NEXT ROW OF CS-ACTION-LIST FOR EVERY UNIQUE KC-NORETURNED. FILL IN NEXT ROW OF CS-QUALIFY-LIST FOR EVERYROW RETURNED. ELIMINATE ALL DUPLICATE CS-QUALIFY ENTRIES.FOR EACH UNIQUE KC-NO, GENERATE KEY UNIQUENESS TEST.CONVERT TO EMBEDDED SQL -- 15 MAY 1986ADD CDMQAL CALL -- 15 MAY 1986ADD CDPBL CALL -- 15 MAY 1986ENHANCE CSQ DUPLICATE ELIMINATION LOGIC -- 15 MAY 1986ADD LUW-NAME AS CDPRE5 PASS-THROUGH PARAMETER -- 22 MAY 1986CHANGE ALL CDPRE6 CALLS TO CDPRE5 -- 23 MAY 1986MOVE SPACES TO NEW FIELD IN CS-QUALIFY -- 3 MAR 1987CHECK FOR "V" IN CSQ-SOURCE BEFORE INSERTING COUNTERIN CSQ-VARIABLE FIELDSET UP A KEY UNIQUENESS TEST FOR EACH UNIQUE KEYKEY CLASS BY POPULATING BOTH THE CS ACTION ANDQUALIFY LISTS. POPULATE A COMPLETELY NEW BOOLEANLIST (CDPBL) AND MOVE ANY CS-QUALIFY ENTRIESNOT IN THE CS-ACTION-LIST TO THE CS-ACTION-LIST(CDMQAL) PRIOR TO THE CDPRE5 CALL.
3-69
![Page 80: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/80.jpg)
PS 62034123130 September 1990
ARGUMENTS:
MODEL-NO DSPLY[S9 (4)]TEMP-XFORM-LIST RECRDNDML-COUNTER DSPLY[9(6)]CS-ACTION-LIST RECRDCS-QUALIFY-LIST RECRDES-ACTION-LIST RECRDES-QUALIFY-LIST RECRDUV-ABBR-LIST RECRDCODE-GENERATOR-TABLE RECRDFCB-1 DSPLY[59(9)]FCB-2 DSPLY[S9(9)]FCB-3 DSPLY[S9(9)]FCB-4 DSPLY[S9(9)]MY-HOST DSPLY [XXX]TARGET-HOST DSPLY [XXX]SOURCE-LANGUAGE DSPLY[X(10)]FCB-E DSPLY[S9(9)]ERRCJR-STAfUS DSPLY [9]LUW-NAME DSPLY[X(30)]RFT RECRDJQG-ATTRIBUTE-PAIR-LIST RECRDBLOCK-S TACK RECRDFIRST-INNER-SELECT DSPLY [9]FORTRAN-VARIABLE-TABLE RECRDSUB-AG DSPLY[X(10)]EMBEDDED-LANGUAGE DSPLY[X(10)]CURSOR-TABLE RECRDWHENEVER-TABLERET-STATUS DSPLY[X(5)]
INCLUDE FILES:
ERRCDMERRFS
3-70
![Page 81: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/81.jpg)
PS 62034123130 September 1990
EODBOOLST
* TXLISTCSALCSQUALESALESQUALUVABBRCGTABLEAPLRFTABLEBLSTACKFORVARCURTABWH-EN TABERRPRO
ROUTINES CALLED:
SQLSCASQLBS1SQLSCHSQLSCCSQLTOCSQ LOSQSQLADRSQLAB 1SQLEXESQLCLSSQ LAD 1SQLFCHCDPRE5CDCIIDCDMQALCDPBLERRPRO
3-71
![Page 82: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/82.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDMPIKPURPOSE: CHECK FOR MODIFICATION OF PARTIAL INHERITED KEYLANGUAGE: VAX-lI COBOLSOURCE FILE: CDMPIKSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
FOR EACH UNIQUE RC-NO IN THE TEMP XFORM LIST, SELECT THETAG-NOS FROM INHERTIED ATT USE WHERE THE RC NOS ARE EQUAL.FOR EACH TAG-NO SELECTED, SEARCH THE TEMP XFORM LIST FORA MATCH. IF FOUND, OK; OTHERWISE GENERATE ERROR MESSAGE.CONVERTED TO EMBEDDED SQL -- 20 MAY 1986IMPROVED ERROR HANDLING -- 20 MAY 1986FOR EACH INHERITED TAG TO BE MODIFIED, CDMPIK MUSTINSURE THAT ALL OF THE OTHER INHERITED TAGS FROM THESAME KEY CLASS ARE ALSO TO BE MODIFIED. IF NOT,THE ERROR MESSAGE MUST IDENTIFY THE MISSINGINHERITED ATTRIBUTES.
ARGUMENTS:
MODEL-NO DSPLY[$9(4)]TEMP-XFORM-LIST RECRDFCB-E DSPLY[$9(9) ]ERROR-STATUS DSPLY[9]RET-STATUS DSPLY[X(5)]
3-72
![Page 83: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/83.jpg)
PS 62034123130 September 1990
* INCLUDE FILES:
ERRCDMERRFSEODTXLISTERRPRO
ROUTINES CALLED:
SQLSCASQLBS1SQLSCHSQ LSCCSQLTOCSQLOSQSQ LADRSQ LAB 1SQLEXESQLCLSSQ LA DSQLFCHCDGTNRPTERRE RRPRO
3-73
![Page 84: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/84.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDMQALPURPOSE: BUILD ES/CS ACTION LIST ENTRIESLANGUAGE: VAX-Il COBOLSOURCE FILE: CDMQALSOURCE FILE TYPE: COBHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
- THIS ROUTINE PLACES ES-QUALIFY AND/ORCS-QUALIFY ENTRIES WHICH ARE NOT REPRESENTED IN THEES-ACTION-LIST AND CS-ACTION-LIST RESPECTIVELY ONTHOSE LISTS IN SUPPORT OF CONCEPTUAL EVALUATIONOF THOSE QUALIFY ENTRIES NOT INTERNALLY EVALUATABLE.
ARGUMENTS:
ES-ACTION-LIST RECRDES-QUALIFY-LIST RECRDCS-ACTION-LIST RECRDCS-QUALIFY-LIST RECRDRET-STATUS DSPLY[X(5)]
INCLUDE FILES:
CHKCDMERRCDMESQUAL
3-74
![Page 85: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/85.jpg)
PS 62034123130 September 1990
CSALCSQUAL
* ESALERRPRO
ROUTINES CALLED:
ERRPRO
3-75
![Page 86: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/86.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDNNECPURPOSE: DETERMINE IF THE VIEW OR DATA ITEMS MAP TO MULTIPLE
ENTITY CLASSESLANGUAGE: VAX-lI COBOLSOURCE FILE: CDNNECSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
CHECK VIEW EC XREF TO SEE IF VIEW IS MAPPED TO MORETHAN ONE ENTITYROUTINE CHANGED FROM COB TO PCO FOR CREATE VIEWENHANCEMENTS - REL 2.3CHECK VIEW-EC-XREF FOR MORE THAN ONE EC-NO.IF MORE THAN ONE EXISTS, GENERATEAN ERROR MESSAGE APPROPRIATE TO THE ES-ACTION.
ARGUMENTS:
USER-VIEW-NO DSPLY[S9 (4)]ES-ACTION-LIST RECRDFCB-E DSPLYI[S9(9)]ERROR-STATUS DSPLY[9]RET-STATUS DSPLY[X(5)]
INCLUDE FILES:
ERRCDM
3-76
![Page 87: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/87.jpg)
PS 62034123130 September 1990
ERIRFSEODESALERRPRO
ROUTINES CALLED:
SQLS CASQLBS1SQLSCHSQ LSCCSQ LTO CSQLOS QSQLADRSQLAB 1SQLEXESQLAD 1SQLFCHRPTERRSQLCLSERRPRO
3-77
![Page 88: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/88.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDPBLPURPOSE: POPULATE BOOLEAN LIST.LANGUAGE: VAX-lI COBOLSOURCE FILE: CDPBLSOURCE FILE TYPE: COBHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
- THIS ROUTINE, FOR TYPE 1 REFERENTIALINTEGRITY AND KEY UNIQUENESS TESTS, BUILDS A COMPLETEBOOLEAN LIST. FOR SELECTS, MODIFYS, DELETES AND TYPE2 REFERENTIAL INTEGRITY TESTS, THIS ROUTINE POPULATESBL-ESQ-PTR'S AND BL-CS-PTR'S.
MODIFIED TO ADD TO BOOLEAN LIST FOR TYPE 2'S WHICH WERERETRIEVED FROM VIEW QUALIFY CRITERIAJUN 1989 - MODIFIED TO ADD CSAL CODES FOR CATEGORY DELETE
ARGUMENTS:
ES-QUALIFY-LIST RECRDCS-QUALIFY-LIST RECRDCS-ACTION-LIST RECRDBOOLEAN-LIST RECRDRET-STATUS DSPLY[X(5)]
INCLUDE FILES:
3-78
![Page 89: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/89.jpg)
PS 62034123130 September 1990
CHKCDMERRCDMESQUALBOOLSTCSALCSQUALERRPRO
ROUTINES CALLED:
ERRPRO
3-79
![Page 90: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/90.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDPDIPURPOSE: VERIFY THE EXISTENCE OF A MAPPED DATA ITEMLANGUAGE: VAX-lI COBOLSOURCE FILE: CDPDISOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
PERFORM SQL SEARCH FOR THE TAG NUMBER OF THE PROJECT DATAITEM WHOSE VIEW NUMBER AND DATA ITEM NUMBER MATCH THE INPUTARGUMENTS AND WHOSE ID MATCHES THE CORRESPONDING DATA ITEMID. IF NOT FOUND, RETURN A TAG NUMBER OF ZERO.THE CALLING PROGRAM GENERATES THE ERROR MESSAGE.MODIFIED FOR EMBEDDED SQL -- 13 MAY 1986PERFORM SQL SELECT OF THE TAG NUMBER FROMPROJECT DATA ITEM GIVEN THE VIEW NUMBER ANDDATA ITEM NUMBER. RETURN A TAG NUMBER OFZERO IF NOT FOUND.
ARGUMENTS:
MODEL-NO DSPLY[S9(4)]VIEW-NO DSPLY[$9(4)]DI-NO DSPLY[$9(4)]TAG-NO DSPLY[S9(4)]RET-STATUS DSPLY[X(5)]
3-80
![Page 91: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/91.jpg)
PS 62034123130 September 1990
INCLUDE FILES:
ERRCDMEODERRPRO
ROUTINES CALLED:
SQLSCASQLBS1S QLS CHS QLS CCS QLTFLSQ LOPNSQ LOS QSQ LADRSQLAB 1SQLEXES QLAD 1SQLFCHERRPRO
3-81
![Page 92: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/92.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDPRE4PURPOSE: EXTERNAL SCHEMA/CONCEPTUAL SCHEMA TRANSFORMATIONLANGUAGE: VAX-lI COBOLSOURCE FILE: CDPRE4SOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
THE FUNCTION OF THIS EXTERNAL-SCHEMA-TO-CONCEPTUAL-SCHEMATRANSFORMER IS TO CONVERT AN NDML REQUEST EXPRESSED INEXTERNAL SCHEMA TERMS INTO ONE OR MORE NDML REQUESTSEXPRESSED IN CONCEPTUAL SCHEMA TERMS. THE CONVERSIONINVOLVES TRANSLATING EACH USER VIEW INTO THE CORRESPONDINGENTITY CLASSES AND EACH DATA ITEM INTO THE CORRESPONDINGATTRIBUTE USE CLASSES. IT ALSO INVOLVES IDENTIFYING THERELATIONAL JOIN OPERATIONS THAT ARE NEEDED TO CONSTRUCTEACH USER VIEW TABLE FROM THE ENTITY CLASS TABLES ANDIDENTIFYING THE INTEGRITY TESTS THAT WILL BE EMPLOYED WITHEACH NDML UPDATE REQUEST. THIS IMPLEMENTATION WILL NOTSUPPORT DERIVED DATA ITEMS.CONVERT TO EMBEDDED SQL -- 10 JUNE 1986DELETE SEC-DECOMPOSITION-LIST -- 10 JUNE 1986DELETE CE-WORK-LIST -- 10 JUNE 1986MAKE CS-ACTION-LIST AN OUTPUT PARAMETER -- 10 JUNE 1986ADD USER-MOD-ID, LUW-NAME AND BOOLEAN-LIST ASINPUT PARAMETERS -- 10 JUNE 1986MAKE NDML-COUNTER PIC 9(6) AND INPUT/OUTPUT PARAMETER --10 JUNE 1986DELETE USER-ERROR-COUNT REFERENCES -- 10 JUNE 1986ADD CHECK FOR MODIFYS AND DELETES WITH USING CLAUSES
3-82
![Page 93: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/93.jpg)
PS 62034123130 September 1990
TO ENSURE THAT THE TARGET VIEW IS JOINED TO --ADD LOGIC TO MOVE CS QUALIFICATIONS TO THE CS ACTIONLIST IN SUPPORT OF COMPLEX MAPPING -- 10 JUNE 1986ADD LOGIC TO CREATE OR ADD TO THE BOOLEAN LIST --ADD LOGIC TO UPDATE THE CDM CROSS REFERENCE -- 10 JUNE 1986ADD CHECK TO INSURE THAT USED ES-VALUES ARE NUMERICWHEN THE DATA TYPE IS NUMERIC -- 10 JUNE 1986POPULATE CSQ-VARIABLE ONLY WHEN ESQ-UV-ABBRR IS BLANK-- 10 JUNE 1986CHECK THAT LEFT AND RIGHT SIDE QUALIFY TYPES ARECOMPATABLE -- 10 JUNE 1986CHANGE INITIALIZATION OF TEMP-XFORM-LIST, CS-QUALIFY-LIST,CS-ACTION-LIST AND TEMP-JOIN-LIST -- 27 FEB 87CHANGE CALL TO CDVIEW TO RETRIEVE DISTINCT IND. IF USERDID NOT SPECIFY 'DISTINCT' BUT ONE VIEW IS DISTINCTED,THEN ES-DISTINCT-FLAG IS SET TO 'YI - 25 FEB 87ADD CALL TO CDGTVW TO PICK UP TYPE 2 QUALIFICATIONSFROM VIEW QUALIFY CRITERIA AND ADD TO CS-QUALIFY ANDADD TO THE BOOLEAN LIST FOR DELETE, MODIFY, SELECTAND QUERY-COMBINATION ACTIONS -- 25 FEB 87CHANGED LOGIC IN DECOMPOSE-USER-VIEW (STEP 9) (SELECT ANDQUERY-COMBINATION ACTIONS) TO RETRIEVE THETYPE 3 QUALIFICATIONS FROM VIEW QUALIFYCRITERIAFOR A SPECIFIC VIEW AND BUILD THE TEMP-JOIN-LIST USINGTHE TAG NUMBERS RETRIEVED - 25 FEB 87CHANGE TO SET A NEW FIELD IN CS-QUALIFY (CSQ-SOURCE) TO'V' IF INFORMATION IS FROM VIEWQUALIFYCRITERIA, ELSESET TO 'U' -- 25 FEB 87CHANGE PARAMETERS TO CALL "CDNNEC" WHICH WAS CHANGEDFROM COB TO PCC -- 25 FEB 87CHANGE PARAMETERS TO CALL "CDEMD" -- 25 FEB 8715-jul-87 -- after all view "joins" have been retrieved, andpopulated, delete any csq entries which have the left aucequal the right auc. this could happen if views are madeup from the same entity(s) 10.52 MAY -1989 -- ADD PROCESSING TO SUPPORT IDEFIX AS FOLLOWS:INSERT - ADD CALL TO CD2NEC TO LOOK UP INTO CATEGORY RELATIONMODIFY - ADD CALL TO CDAUC TO DETERMINE IF CATEGORYDISCRIMINATOR IS BEING MODIFIED.ADD CALL TO CDCRIT TO LOOK UP INTO CATEGORY RELATION
3-83
![Page 94: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/94.jpg)
PS 62034123130 September 1990
FOR TYPE 1.DELETE - ADD CALL TO CDERC TO DETERMINE IF ENTITY IS GENERICIF ENTITY IS NOT GENERIC - FOLLOWING CALLS ARE BY PASSED:ADD CALL TO CDASEL FOR SELECT FOR CASCADE IF ENTITYIS GENERIC.ADD CALL TO CDELIS TO BUILD LIST OF TYPE 2'S ANDLIST OF ENTITIES FOR CASCADE DELETEADD CALL TO CD2SEL TO BUILD TYPE 2'SADD CALL TO CDZDEL TO BUILD CASCADE DELETES2 MAY 1989 - ADD A NEW ROW TO TEMP-XFORM-LIST TO HOLDCATEGORY TYPEADD A NEW .INC TO HOLD TABLE OF ECS FROM WHICH TOBUILD TYPE 2'S FOR CASCADE DELETEADD A NEW .INC TO HOLD TABLE OF ENTITIES TO BEDELETED FOR CASCADE DELETE.ADD A NEW CS-QUALIFY CLONE TO HOLD CS-QUALIFICATIONSFOR CASCADE DELETE SO AS NOT TO DESTROY USER'SQUALIFICATIONS.
ARGUMENTS:
ES-QUALIFY-LIST RECRDES-ACTION-LIST RECRDCS-QUALIFY-LIST RECRDUV-ABBR-LIST RECRDCS-ACTION-LIST RECRDFCB-1 DSPLY[$9(9)]FCB-2 DSPLY($9(9)]FCB-3 DSPLY[S9 (9) ]FCB-4 DSPLY[S9(9) ]FCB-E DSPLY [$9 (9)]MY-HOST DSPLY[XXX]TARGET-HOST DSPLY[XXX]SOURCE-LANGUAGE DSPLY[X(10)]CODE-GENERATOR-TABLE RECRDUSER-MOD-ID DSPLY[X(10)]LUW-NAME DSPLY[X(30)]NDML-COUNTER DSPLY[9(6)]BOOLEAN-LIST RECRD
3-84
![Page 95: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/95.jpg)
PS 62034123130 September 1990
RFT RECRDJQG-ATTRIBUTE-PAIR-LIST RECRDBLOCK-STACK RECRDNDML-STACK RECRDFIRST-INNER-SELECT DSPLY [9]FORTRAN-VARIABLE-TABLE RECRDSUB-AG DSPLY[X(10)]EMBEDDED-LANGUAGE DSPLY[X(10)]CURSOR-TABLE RECRDWHENEVER-TABLERET-STATUS DSPLY[X(5)]
INCLUDE FILES:
ERIRCDMERRFSCSQ VARDELCATTYP2TBEOTJLISTTXLISTNDMLSTKBLSTACKESQUALESALCSQUALUVA BBRCSALAPLRFTABLEFORVARCGTABLEBOO LSTCURTABWHEN TA BERR PRO
3-85
![Page 96: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/96.jpg)
PS 62034123130 September 1990
ROUTINES CALLED:0
RPTERRCDGTVWCDMQALCDPBLCDPRE5CDIDIUERRPROCDVIEWCDABVWCDEMDACDEMDCDPDICDCMDCDPTECCDINECCD2 NECCDKYUQCDACALCDNNECCDATXLCDRCTGC DUTX LCDVTGKC DMP 1KCD1RITCDCRITCDJUVCDAUCC DTGVWCD2RITCDERCC DAS ELODELISCD2SELCDZ DEL
3-86
![Page 97: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/97.jpg)
PS 62034123130 September 1990
CDVNVCDRCNRSQLSCASQLBS1SQLSCHSQLS CCSQLADR
& SQLAD1SQLFCHSQLTFLSQLOPNS QLOSQSQLAB 1SQLEXESQLTOC
3-87
![Page 98: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/98.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation4
NAME: CDPTECPURPOSE: DETERMINE WHETHER VIEW MAPS TO PART OF AN ENTITY
CLASSLANGUAGE: VAX-Il COBOLSOURCE FILE: CDPTECSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
INSURE THAT TAG NUMBER EXTRACTED FROM ATTRIBUTEUSECLMATCHES AT LEAST 1 TEMP-AUC, OTHERWISE, ERROR.CONVERTED TO EMBEDDED SQL, ALL USER-ERROR-COUNTREFERENCES DELETED -- 14 MAY 1986FOR EACH TAG BELONGING TO AN ENTITY CLASS,FIND IF IT IS EQUAL TO AT LEAST ONE TEMP-AUC.IF NOT, GENERATE AN ERROR MESSAGE APPROPRIATETO THE ES-ACTION.
ARGUMENTS:
MODEL-NO DSPLY[$9(4)]TEMP-XFORM-LIST RECRDES-ACTION-LIST RECRDFCB-E DSPLY[S9 (9)]ERROR-STATUS DSPLY[9]RET-STATUS DSPLY[X(5)]
3-88
![Page 99: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/99.jpg)
PS 62034123130 September 1990
INCLUDE FILES:
ERRCDMERRFSEQDTXLISTESALERRPRO
ROUTINES CALLED:
SQLSCASQLBS 1SQLS CHS QLS CCSQLTOCS QLOSQSQLADRSQLAB 1SQLEXESQLCLSRPTERR,SQLAD 1SQLFCHERRPRO
3-89
![Page 100: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/100.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDRCNRPURPOSE: OBTAIN RELATION CLASS NUMBER FOR OUTER JOINLANGUAGE: VAX-lI COBOLSOURCE FILE: CDRCNRSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
- SEARCH INHERITED ATT USE TABLE FOR THERC NO WHOSE TAG-NO MATCHES THE INPUT ARGUMENT.
CONVERTED TO EMBEDDED SQL -- 20 MAY 1986REPLACED ALL "NOT IN SET" REFERENCES WITH"OUTER JOIN" REFERENCES -- 20 MAY 1986
PERFORM SINGLE-ROW SELECT TO RETRIEVE THE RELATIONCLASS NUMBER GIVEN THE TAG NUMBER OF THE INHERITEDATTRIBUTE IN SUPPORT OF THE OUTER JOIN.
ARGUMENTS:
MODEL-NO DSPLY[$9 (4)]TAG-NO DSPLY[$9 (4)]RC-NO DSPLY[$9(4)]RET-STATUS DSPLY[X(5)]
INCLUDE FILES:
ERRCDM
3-90
![Page 101: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/101.jpg)
PS 62034123130 September 1990
EODERRPRO
ROUTINES CALLED:
SQLSCASQLBS1SQLSCHSQLS CCSQLTFLSQLOPNSQLOSQSQLADRSQLAB1SQLEXESQLAD 1SQLFCHERRPRO
3-91
![Page 102: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/102.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDRCTGPURPOSE: GET THE RC AND OWNER TAG OF AN INHERITED ATTRIBUTELANGUAGE: VAX-lI COBOLSOURCE FILE: CDRCTGSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
PERFORM SQL SEARCH OF THE INHERITED-ATT-USE TABLE LOOKINGFOR RELATION CLASS NUMBER AND KEY CLASS MEMBER TAG NUMBERWHERE THE TAG NUMBER MATCHES THE INPUT PARAMETER.CONVERTED TO EMBEDDED SQL -- 19 MAY 1986ADD RETRIEVAL OF RELATION TYPE -- 2 MAY 1989PERFORM 1-ROW SELECT OF RC NUMBER AND KCM TAG NUMBERGIVEN THE TAG NUMBER. PERFORM STANDARD ERROR HANDLING.
ARGUMENTS:
MODEL-NO DSPLY[S9 (4)]TAG-NO DSPLY[$9(4)]RC-NO DSPLY[$9(4)]KCM-TAG-NO DSPLY[S9 (4)]RELATION-TYPE DSPLY[X(30) ]RET-STATUS DSPLY[X(5)]
INCLUDE FILES:
ERRCDM
3-92
![Page 103: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/103.jpg)
PS 62034123130 September 1990
EODERRPRO
ROUTINES CALLED:
SQLSCASQLBS1SQLSCHSQLS CCSQ LTFLSQLOPNSQLOSQSQLADRSQLAB 1SQLEXES QLAD 1SQLFCHERRPRO
3-93
![Page 104: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/104.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDTGVWPURPOSE: RETRIEVE ALL TAGS TO WHICH A VIEW MAPSLANGUAGE: VAX-lI COBOLSOURCE FILE: CDTGVWSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
SELECT ALL TAGS FOR A VIEW, RETRIEVE CONCEPTUAL METADATA ANDFILL INA ROW OF THE TEMP-XFORM-LIST FOR EACH TAG SELECTED.CONVERT TO EMBEDDED SQL -- 2 JUNE 1986MODIFY NDML-COUNTER TO PIC 9(6) -- 2 JUNE 1986DELETE USER-ERROR-COUNT AS OUTPUT PARAMETER -- 2 JUNE 1986SEARCH PROJECT DATA ITEM FOR ALL TAGS IN THE GIVENVIEW. FOR EACH TAG, EXTRACT CONCEPTUAL METADATA ANDFILL IN A NEW ROW OF THE TEMP-XFORM-LIST.
ARGUMENTS:
MODEL-NO DSPLY[S9(4)]VIEW-NO DSPLY[S9(4)]ES-INDEX DSPLY[99]NDML-COUNTER DSPLY[9(6)]ERROR-FILE DSPLY[X(30)]TEMP-XFORM-LIST RECRDERROR-STATUS DSPLY[9]RET-STATUS DSPLY[X(5)]
3-94
![Page 105: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/105.jpg)
PS 62034123130 September 1990
INCLUDE FILES:
ERRCDMEODTXLISTERRPRO
ROUTINES CALLED:
SQLS CASQLBS1SQLSCHSQLS CCSQ LTO CS QLOSQSQLADRSQLAB 1SQ LE XESQLCLSSQLADISQLFCHCDCMDCDATXLERRPRO
3-95
![Page 106: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/106.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDUTXLPURPOSE: UPDATE A ROW OF THE TEMP-XFORM-LISTLANGUAGE: VAX-Il COBOLSOURCE FILE: CDUTXLSOURCE FILE TYPE: COBHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
UPDATE THE TEMP-RC-NO AND THE TEMP-KCM-TAG-NO AND TEMP-RELATIONENTRIES OFTHE CURRENT ROW OF THE TEMP-XFORM-LIST WITH THE INPUTPARAMETERS.MODIFY FOR TEMP TRANSFORM LIST EXPANSION -- 19 MAY 1986MODIFY FOR TEMP TRANSFORM LIST CHANGE TO INCLUDE RELATION TYPE=2 MAY 1989UPDATE THE CURRENT TEMP-RC-NO AND TEMP-KCM-TAG-NO.
ARGUMENTS:
RC-NO DSPLY[S9(4)]KCM-TAG-NO DSPLY[S9(4)]RELATION-TYPE DSPLY[X(10)]TEMP-XFORM-LIST RECRD
INCLUDE FILES:
TXLIST
3-96
![Page 107: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/107.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDVIEWPURPOSE: VERIFY THE EXISTENCE OF A VIEW IN THE CDMLANGUAGE: VAX-lI COBOLSOURCE FILE: CDVIEWSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
PERFORM SQL SEARCH OF TABLE SEC TO VERIFY A VIEWGIVEN THE VIEW NAME. THE VIEW NUMBER IS RETURNED. IF THE VIEWDOESN'T EXIST, 0 IS RETURNED AS THE VIEW NUMBER.
MODIFIED TO EMBEDDED SQL - 5/5/86SEARCH FOR USER VIEW NUMBER GIVEN USER VIEW NAME.IF NOT FOUND, GENERATE ERROR MESSAGE.
ARGUMENTS:
VIEW-NAME DSPLY[X(30)]FCB-E DSPLY[S9(9)]VIEW-NO DSPLY[$9(4)]DISTINCT-IND DSPLY[X]RET-STATUS DSPLY[X(5)]
INCLUDE FILES:
ERRCDMERRFSEOD
3-97
![Page 108: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/108.jpg)
PS 620341231
30 September 1990
ERRPRO
ROUTINES CALLED:
SQLSCASQLBS1SQLSCHSQLS CCSQ LT FLSQLOPNSQLOSQSQLADRSQLAB 1SQLEXES QLAD 1SQLFCHRPTERRERRPRO
3-98
![Page 109: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/109.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDVNVPURPOSE: CDVNV - VERIFY A NUMERIC VALUELANGUAGE: VAX-Il COBOLSOURCE FILE: CDVNVSOURCE FILE TYPE: COBHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
FUNCTION CDVNV VALIDATES A CHARACTER STRING TO DETERMINEWHETHER IT IS NUMERIC. THE FOLLOWING RULES ARE APPLIED:1. A SIGN, IF PRESENT, MUST BE EITHER "+" OR "-" ANDMUST IMMEDIATELY PRECEED A DECIMAL DIGIT OR DECIMALPOINT.2. THE NUMBER, INCLUDING SIGN, DOES NOT HAVE TO BE LEFTJUSTIFIED IN THE FIELD, AS LONG AS THERE ARE NOEMBEDDED BLANKS.3. THERE MAY BE, AT MOST, ONE DECIMAL POINT.4. A DECIMAL NUMBER MUST EITHER PRECEED OR FOLLOW THEDECIMAL POINT. A DECIMAL NUMBER MAY BOTH PRECEEDAND FOLLOW THE DECIMAL POINT.5. AT LEAST ONE DECIMAL DIGIT MUST APPEAR IN THE NUMBER.IF VIOLATIONS OF THE ABOVE RULES OCCURS, AN ERROR MESSAGEIS GENERATED.APPLY RULES 1 THROUGH 5. GENERATE FATAL ERROR MESSAGEIF NECESSARY.
ARGUMENTS:
3-99
![Page 110: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/110.jpg)
PS 62034123130 September 1990
VALUE-IN RECRDDATA-ITEM DSPLY(X(30) IFCB-E DSPLY[S9(9)]ERROR-STATUS DSPLY [9]
ROUTINES CALLED:- - - - - - - - - - - - -
RPTERR
3-100
![Page 111: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/111.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Module Documentation
NAME: CDVTGKPURPOSE: VERIFY THAT A TEMP-AUC IS NOT A KEY CLASS MEMBERLANGUAGE: VAX-lI COBOLSOURCE FILE: CDVTGKSOURCE FILE TYPE: PCOHOST:SUBSYSTEM: CDMSUBDIRECTORY: NDML
DESCRIPTION:
PERFORM SQL SEARCH OF KEYCLASSMEMBER ON ALL TEMP-AUCS TOVERIFYTHAT THE TAG IS NOT A KEY CLASS MEMBERCONVERTED TO EMBEDDED SQL -- 19 MAY 1986PERFORM SINGLE-ROW SELECT OF ALL TEMP TAGS TOVERIFY THAT THEY ARE NOT MEMBERS OF THEKEY CLASS MEMBER TABLE. IF FOUND, GENERATE ANERROR MESSAGE.
ARGUMENTS:
MODEL-NO DSPLY[S9 (4)]TEMP-XFORM-LIST RECRDES-ACTION-LIST RECRDFCB-E DSPLY[S9 (9)]ERROR-STATUS DSPLY[9]RET-STATUS DSPLY[X(5)]
INCLUDE FILES:
ERRCDM
3-101
![Page 112: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/112.jpg)
PS 62034123130 September 1990
ERRFSEODTXLISTESALERR PRO
ROUTINES CALLED:
SQLSCASQLBS1SQLSCHSQLS CCSQLTFLSQLOPNSQLOS QSQLADRS QLAB 1SQLEXESQLAD 1SQLFCHRPTERR,ERRPRO
3-102
![Page 113: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/113.jpg)
PS 62034123130 September 1990
3.10.5 Include File Descriptions
The following list contains a purpose and description ofeach include file in the documentation group as specified inthe source code. The language it is written in is also given.
3-103
![Page 114: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/114.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: APLPURPOSE: JOIN QUERY ATTRIBUTE PAIR LISTLANGUAGE: VAX-11 COBOL
DESCRIPTION:
CONTAINS INFORMATION ABOUT THE JOINATTRIBUTES FOR NDML SUBTRANSACTIONS
3-104
![Page 115: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/115.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: BLSTACKPURPOSE: EXTERNAL SCHEMA QUALIFY LISTLANGUAGE: VAX-lI COBOL
DESCRIPTION:
CONTAINS EXTERNAL SCHr A INFORMATION FOR THE NDMLQUALIFICATION
THE EXTERNAL SCHEMA QUALIFY LIST
3-105
![Page 116: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/116.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: BOOLSTPURPOSE: BOOLEAN LISTLANGUAGE: VAX-11 COBOL
DESCRIPTION:
CONTAINS THE BOOLEAN OPERATORS, PARENTHESES, ANDPOINTERS TO THE TYPE 2 CONDITIONS FOR AN NDMLTRANSACTION
3-106
![Page 117: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/117.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: CGTABLEPURPOSE: CODE GENERATING TABLE- TRACKS ALL GENERATED SOFTWARELANGUAGE: VAX-l1 COBOL
DESCRIPTION:
HOLDS PERTINENT RESULTSABOUT ALL CODE GENERATED OR MODIFIED BY THEPRECOMPI LER
3-107
![Page 118: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/118.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: CHKCDMPURPOSE: IISS CDMP CHECK STATUS CODESLANGUAGE: VAX-lI COBOL
DESCRIPTION:
CONTAINS ALL STATUS CODES FOR THE *CDMP MODULES *
3-108
![Page 119: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/119.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: CSALPURPOSE: CONCEPTUAL SCHEMA ACTION LISTLANGUAGE: VAX-11 COBOL
DESCRIPTION:
TABLE TO HOLD CONCEPTUAL DATA ABOUT THE REQUEST
NOTE!!!!!! This table is cloned in both cdpre5 and cdpre4
3-109
![Page 120: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/120.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: CSQUALPURPOSE: CONCEPTUAL SCHEMA QUALIFY LISTLANGUAGE: VAX-lI COBOL
DESCRIPTION:
CONTAINS CONCEPTUAL SCHEMA INFORMATION FORTHE REQUEST'S QUALIFICATION
NOTE!!!!!This table is cloned as CSQUALX in CDPRE4. If itis changed, CSQUALX must be changed also.
THE CONCEPTUAL SCHEMA QUALIFY LIST
3-110
![Page 121: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/121.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: CSQVARPURPOSE: SQL END OF DATA DEFINITIONLANGUAGE: VAX-Il COBOL
DESCRIPTION:
3-111
![Page 122: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/122.jpg)
PS 620341231Aloan
DOCGROUP PS41231 Include File Description
FILE NAME: CURTABPURPOSE: PROCESS ERROR INCLUDE FILELANGUAGE: VAX-Il COBOL
4
DESCRIPTION:
3-112
![Page 123: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/123.jpg)
PS 620-4123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: EODPURPOSE: SQL END OF DATA DEFINITIONLANGUAGE: VAX-Il COBOL
DESCRIPTION:
3-113
![Page 124: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/124.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: ERRCDMPURPOSE: IISS ERROR STATUS CODES FOR CDMP MODULESLANGUAGE: VAX-Il COBOL
DESCRIPTION:
CONTAINS ALL ERROR CODES USED BY CDMP *MODULES FOR ERROR HANDLING *
3-114
![Page 125: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/125.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: ERRFSPURPOSE: ERRFS.INC - FILE I/O PRIMITIVES (FILE SERVICES)LANGUAGE: VAX-lI COBOL
DESCRIPTION:
IISS ERROR CODES
THIS FILE DEFINES THE FS STATUSCODES IN COBOL FORMAT
3-115
![Page 126: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/126.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: ERRPROPURPOSE: PROCESS ERROR INCLUDE FILELANGUAGE: VAX-11 COBOL
DESCRIPTION:
3-116
![Page 127: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/127.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: ESALPURPOSE: EXTERNAL SCHEMA ACTION LISTLANGUAGE: VAX-11 COBOL
DESCRIPTION:
CONTAINS THE EXTERNAL SCHEMA INFORMATION FOR ANNDML REQUEST
THE EXTERNAL SCHEMA ACTION LIST
3-117
![Page 128: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/128.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: ESQUALPURPOSE: EXTERNAL SCHEMA QUALIFY LISTLANGUAGE: VAX-lI COBOL
DESCRIPTION:
CONTAINS EXTERNAL SCHEMA INFORMATION FOR THE NDMLQUALIFICATION
THE EXTERNAL SCHEMA QUALIFY LIST
3-118
![Page 129: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/129.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Descriptionq
FILE NAME: FORVARPURPOSE: FORTRAN VARIABLE TABLELANGUAGE: VAX-Il COBOL
DESCRIPTION:
THIS TABLE HOLDS THE ORIGINAL FORTRAN VARIABLEAND ITS GENERATED SIX-CHARACTER COUNTERPART.
3-119
![Page 130: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/130.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description p
FILE NAME: NDMLSTKPURPOSE: NDML COMMAND NESTING INFORMATIONLANGUAGE: VAX-11 COBOL
DESCRIPTION:
3-120
![Page 131: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/131.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: RFTABLEPURPOSE: THE RESULT FIELD TABLELANGUAGE: VAX-Il COBOL
DESCRIPTION:
3-121
![Page 132: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/132.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: TJLISTPURPOSE: TEMP JOIN LISTLANGUAGE: VAX-11 COBOL
DESCRIPTION:
THIS WILL TEMPORARILY STORE META-DATA ABOUTJOINED ENTITY CLASSES MAKING UP A USER VIEW
3-122
![Page 133: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/133.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: TXLISTPURPOSE: TEMP TRANSFORM LISTLANGUAGE: VAX-11 COBOL
DESCRIPTION:
THIS WILL TEMPORARILY STORE METADATA ABOUT ANNDML UPDATE REQUEST EXPRESSED IN CS TERMS(INTERNAL TO PRE4)
3-123
![Page 134: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/134.jpg)
PS 62034123130 September 1990
DOCGROUP PS41231 Include File Description
FILE NAME: UVABBRPURPOSE: USER VIEW ABBREVIATION LISTLANGUAGE: VAX-11 COBOL
DESCRIPTION:
CONTAINS THE ABBREVIATIONS FOR ALL USERVIEW REFERENCED IN THE NDML REQUEST
3-124
![Page 135: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/135.jpg)
PS 62034123130 September 1990
3.10.6 Hierarchy Chart
--------- +-------- -------
ICDPRE41 ICDRCNRI ICDVNVI2--- ------ --------3 -+-
IRPTERR I
3-12 5
![Page 136: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/136.jpg)
PS 62034123130 September 1990
2
CDPRE41
+-------------------- -------------
---------- ---- +------ ---- +------ ---- +----- --------
IRPTERR I ICDGTVW I ICDMQAL I jCDPBL I I (CONT) I------- +------4+ - +---+------ ---- +----- +---- 5+
IERRPRO I IERRPRO I+------ -------- +
3-126
![Page 137: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/137.jpg)
PS 62034123130 September 1990
3
I CDRCNR I
------------------------ +-----------------+----------------
ISQLSCA I ISQLBS1 I ISQLSCH I jSQLSCC I I (CONT)l----------- +---------- +---------- +---------- +------ 6+
3-127
![Page 138: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/138.jpg)
PS 62034123130 September 1990
4+------------
ICDGTVW I i
------ ------------ +-------------------- ----------------------
IIII I------ + +--------- --------- +--------- - -------
ISQLSCA I ISQLBS1 I jSQLSCH I ISQLSCC I I (CONT) I------------- +------------ +------------ +------------ +------- 7+
3-128
![Page 139: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/139.jpg)
PS 62034123130 September 1990
5
CDPRE41
------------- +-------------------------------------+--------------------
-------- 2+ - ------------- ------------- +------------ +------- 8+
3-129
![Page 140: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/140.jpg)
PS 62034123130 September 1990
I CDRCNRI
---- ---------------------------------- +--------------------
+--+I---- ---- +I----+ +---+I----+ +---+I----- +--+I---+
j(CONT)l ISQLTFL I ISQLOPN I ISQLOSQ I I(CONT)l-------- 3+ -------------- +------------ +------------ +------- 9+
3-130
![Page 141: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/141.jpg)
PS 62034123130 September 1990
7+------------
ICDGTVWI
+-------------------------+------------+----------------r
I II0 --- +---+-----+ +---+-----+ +---+-----+ -----
I(CONT)lI SQLTOC I ISQLOSQ I ISQLADR I I(CONT)l-------- 4+ -------------- +------------ +------------ ----- 20+
3-131
![Page 142: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/142.jpg)
PS 62034123130 September 1990
CDPRE41I
-- +-----------------------+--------------------
I(CONT)I ICDVIEW I ICDABVW I ICDEMDA I I(CONT)l-------- 5+ +---------- 11+ - ------------- --------- 12+ -+---- 13+
3-132
![Page 143: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/143.jpg)
PS 62034123130 September 1990
9
ICDRCNR,
-r - +----------------------------------------------+--------+
+--+----+ +---+-....+ +---- ... + +----- ... + +--+---+I(CONT)I ISQLADR I ISQLAB1 I JSQLEXE I I(CONT)I
+------ 6+ +- ---------- ----------+ ---------- - + 14+
3-133
![Page 144: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/144.jpg)
PS 62034123130 September 1990
10+------------
JCDGTVW I
S+------------------ -----
+-------+---+-----------+-----------+------ -----
I(CONT)I ISQLAB1 I ISQLEXE I ISQLAD1 I I(CONT)I+-------7+ - ------------- +------------ +------------ ----- 15+
3-134
![Page 145: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/145.jpg)
PS 62034123130 September 1990
+------------
ICDVIEW I++-----------+---------------+
*1--------------------------------- -- -- - --- -- - -- -
ISQLSCA I ISQLBS1 I ISQLSCH I (SQLSCC I I (CONT) I------------- +------------ +------------ ------------- +----16+
3-135
![Page 146: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/146.jpg)
PS 62034123130 September 1990
12+------------
ICDEMDAI1~- -+-------------------------------------------+I
+-------------+-----------+-----------+----------+
ISQLSCA I ISQLBS1 I ISQLSCH I ISQLSCC I I (CONT)l+------------ ------------- ------------- ------------ ++--7
3-136
![Page 147: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/147.jpg)
PS 62034123130 September 1990
13
CDPRE41
----------- +-------------+------------------ -+------------------
I I I II+-------- ---- +----- ---- +----+ ---- +----- --------
l(CONT)I ICDEMD I jCDPDI I ICDCMD I l(CONT)I-------- 8+ --------- 18+ --------- 19+ --------- 20+ ------ 21+
3-137
![Page 148: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/148.jpg)
PS 62034123130 September 1990
14
ICDRCNRI
-------------------------------II I-----I
------ +---------- ---------------
I(OT~ SQLAD1 I ISQLFCH I ERO I------ 9+ -------------- +------------ +------------
3-138
![Page 149: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/149.jpg)
PS 62034123130 September 1990
15+------------
jCDGTVW I
+------------------------------+---------------------- ----
+--+I---- ---- I+----+ +---+I----+ +---+I----+ +--+I---+
I(CONT)I ISQLFCH I ISQLTFL I ISQLOPN I I(CONT)I+---- +------------ +------------ ------------- -----22+
3-139
![Page 150: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/150.jpg)
PS 62034123130 September 1990
16+------------
ICDVIEW I1 ~+-------------------------------------------+
I+-------+----+-----------+-----------+----+-------
l(CONT)I ISQLTFL I ISQLOPN IJSQLOSQ !i(CONT)I+---- +------------ +------------ +------------ -----23+
3-140
![Page 151: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/151.jpg)
PS 62034123130 September 1990
17+------------
A I CDEMDA I+----------
+----------+--------------+------------------ ----- --------------------I
+--+---+ +-------+ +-------+ +-------+ +--+---+I(CONT) I ISQLTOC I ISQLOSQ I ISQLADR I '(CONT)+ -12+ -----------+ ---------- ----------+ r----24+
3-141
![Page 152: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/152.jpg)
PS 62034123130 September 1990
18
ICDEMDI
------ ------ ------ --- ---------------- - - - - -
+---+I----+ +---+I----- +---+I----+ +---+I----+ +--+I---+
ISQLSCA 1 ISQLBS1 I ISQLSCH I ISQLSCC I I(CONT)i------------- +------------ ------------- ---------- +----25+
3-142
![Page 153: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/153.jpg)
PS 62034123130 September 1990
19
!CDPDI I
+--------------------------+-----------------------+--------------------
ISQLSCA I ISQLBS1 I SQLSCH I ISQLSCC I I(CONT)l------------- +------------ +------------ ------------- +----26+
3-14 3
![Page 154: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/154.jpg)
PS 62034123130 September 1990
20
CDCMD 1
*1---------------------------+-----------------------+--------------
+-- I--+ + --- +I----+ +---+I----+ +---+I----+ +--+I---+
ISQLSCA I ISQLBS1 I ISQLSCH I ISQLSCC I I (CONT)l------------- +------------ +------------ +------------ +---- 27+
3-144
![Page 155: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/155.jpg)
PS 62034123130 September 1990
21
CDPRE41
1------ +-------------- -- +-----------------------------
III I----I+-------+ ---------- ---------- ---------- --------
I(CONT)I ICDPTEC I ICDINEC I jCD2NEC I I(CONT)I+----13 ---------- 28+ +---------- +------------ +----29+
I------ --------------------------------- ----------------------
ISQLSCA I ISQLBS1 I ISQLSCH IISQLSCC I I(CONT)j------------- ------------- +------------ +------------ +----30+
3-145
![Page 156: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/156.jpg)
PS 62034123130 September 1990
221ICDGTVWI
I----+-----+------- 1I I
+--------+------- +---+----+ +-------
I(CONT)l JCDCMD I ISQLCLS I JERRPRO I+----15+ ----- 20+ -+-------- --------
3-146
![Page 157: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/157.jpg)
PS 62034123130 September 1990
23+------------
JCDVIEW I+------------
------ --------------------- ----------
+--+I---- ---- +I----+ +---+I----+ +---+I----+ +--+I--- +
I(CONT)I ISQLADR I fSQLAB1 I (SQLEXE I I(CONT)I----- 16 -------------- +------------ +------------ -----31+
3-147
![Page 158: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/158.jpg)
PS 62034123130 September 1990
24+------------
ICDEMDA I-+-------------+------------+----------------+
II------- +---+-----------+-----------+-----------
I(CONT)I ISQLAB1 I ISQLEXE I ISQLCLS I I(CONT)l+---- ------------- +------------ +------------ -----32+
3-148
![Page 159: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/159.jpg)
PS 62034123130 September 1990
25
JCDEMD I
+------------------------------+--------------------- -----
I(CONT)I JSQLTFL I ISQLOPN I ISQLOSQ II(CONT)I+--- ------------- +------------ +------------ ----- 33+
3-149
![Page 160: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/160.jpg)
PS 62034123130 September 1990
26
jCDPDI I
-----------------------------------------------
II I II+-------+ ---- +------ ---- +------ ---------- +--------
(CONT)l I SQLTFL I ISQLOPN I ISQLOSQ I I (CONT) I+----19+ - ------------- ------------- ------------- -----34+
3-150
![Page 161: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/161.jpg)
PS 62034123130 September 1990
27
ik ICDCMD I
------------------------------------III I-----I
+-------- ---------- ---------- ---------- --------
I(CONT)I ISQLTFL I ISQLOPN I JSQLOSQ I I(CONT)I+----20+ -------------- ------------- +------------ ----- 35+
3-151
![Page 162: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/162.jpg)
PS 62034123130 September 1990
28+------------
ICDPTEC I+-------------------------+-----------------------------+
I+------ +---+----- +---+----- +---+----- -----
ISQLSCA I ISQLBS1 I ISQLSCH I ISQLSCC I I (CONT) I------------- +------------ ------------- +------------ +---- 36+
3-152
![Page 163: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/163.jpg)
PS 62034123130 September 1990
29
CDPRE41
-- - - - -- - -- - - - - ---- --- - - - -- -------+-------+ ---- +------ ---- +------ ---- +------ --------
I (CONT) I ICDKYUQ I ICDACAL I ICDNNEC I I (CONT)l+----21+ - +-----37+ - -------- ------ 38+ ------ 39+
---------
+---+I---- ---- +I-----
ICDCAT I IERRPRO I+----- +------
3-153
![Page 164: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/164.jpg)
PS 62034123130 September 1990
30+------------
JCDINEC I
-r -+-------------------+---------------------------III I-----I
+-------+ ---------- ---------- ---------- --------
I(CONT)lI SQLTOC I ISQLOSQ I ISQLADR I I(CONT)I-----21+ -------------- +------------ +------------ ----- 40+
3-154
![Page 165: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/165.jpg)
PS 62034123130 September 1990
31+------------
ICDVIEW I~1- -- ------------- +-------------+-----------------+
I I+-- --- -- +---+----- ------ +----- ------ +-- - - - --
I (CONT)l I SQLAD1 I ISQLFCH I IRPTERR I IERRPRO 1+----23+ ------------- +------------ ------------- +------------
3-155
![Page 166: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/166.jpg)
PS 62034123130 September 1990
32+------+-
ICDEMDA III
+--+---+- +---4----+ ---- +------ ---- +------
(CONT)l J SQLAD1 I ISQLFCH I IERRPRO I+---- 24+ -+------ +-----+- +------
3-156
![Page 167: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/167.jpg)
PS 62034123130 September 1990
33
ICDEMD I
---------------- +--------------------------------p I I I
+--+----+ +-------+ +-------+ +---+----+ +--+---+I(CONT)I ISQLADR I SQLAB1 I ISQLEXE I I(CONT):+---- 25+ +- ----------+ +---------- ----------+ +---- 41+
3-157
![Page 168: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/168.jpg)
PS 62034123130 September 1990
34
ICDPDI I
----------- +----------------+------------------ -- +-------------------
III II+-------+ ---- +------ ---- +------ ---- +------ --------
I(CONT)I ISQLADR I JSQLAB1 I ISQLEXE I I(CONT)l+---2+ +------------- +------------ ------------- -----42+
3-158
![Page 169: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/169.jpg)
PS 62034123130 September 1990
35
ICDCMD I
-----------------------------------------------
------------------------------------------- I I I+-------- ---- +------ ---- +------ ---- +------ --------
I(CONT)I ISQLADR I ISQLABI i ISQLEXE I I(CONT)I+----27+ - ------------- +------------ +------------ -----43+
3-159
![Page 170: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/170.jpg)
PS 62034123130 September 1990
36+------------
ICDPTEC I
----------+--------+---------------------------.--------+
I(CONT)I ISQLTOC I JSQLOSQ I ISQLADR I I(CONT)i+---- 28+ - ------------- +------------ +------------ -----44+
3-160
![Page 171: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/171.jpg)
PS 62034123130 September 1990
37+------------
ICDI<YUQ I
+-----------
+------------+-----------+-----------+----------+
JSQLSCA I ISQLBS1 I ISQLSCH I ISQLSCC I I(CONT)I------------- +------------ +------------ ------------- +----45+
3-161
![Page 172: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/172.jpg)
PS 62034123130 September 1990
38+------------
ICDNNEC I+----------------
------------------- -- +-----------------------------
ISQLSCA I ISQLBS1 I ISQLSCH I ISQLSCC I I (CONT) I------------- +------------ +------------ +------------ +----46+
3-162
![Page 173: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/173.jpg)
PS 62034123130 September 1990
39
b I CDPRE41
------------- ------- ------------- +
III II9 -------- ---------- +---------- ---------- --------
I(CONT)I ICDATXL I (CDRCTC I ICDUTXL II(CONT)I+----29+ - +---+------ ------ 47+ - +-------- -----48+
IERRPRO i+-------
3-163
![Page 174: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/174.jpg)
PS 62034123130 September 1990
40+------------
ICDINEC I-r -+-------------+-----------------------------±II
+-----------+-----------+-----------+-----------
(CONT) j ISQLAB1 I ISQLEXE I ISQLCLS I I (CONT) I+----30+ -------------- +------------ +------------ -----49+
3-164
![Page 175: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/175.jpg)
PS 62034123130 September 1990
41
ICDEMDI
-r -+----------------- -+-------------------------------------
III II+-------- ---------- ---------- ---------- +----------
I(CONT)I ISQIAD1 I jSQLFCH I IRPTERR I IERRPRO I-----33+ -------------- +------------ ------------- ------------
3-165
![Page 176: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/176.jpg)
PS 62034123130 September 1990
42
ICDPDI I
----------------------- I--------+-------+ ---------- ---- +------ --------
I (CONT) I ISQI.AD1 I ISQLFCH I IERRPROI1+----34+ -------------- +------------ +------------
3-166
![Page 177: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/177.jpg)
PS 62034123130 September 1990
43
ICDCMD I
+---------+----- -+---------------------
I(OT I SQLAD1 I ISQLFCH I IERRPRO I+----35+ ---------- ------------- ------------
3-167
![Page 178: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/178.jpg)
PS 62034123130 September 1990
44+------------
ICDPTEC 4
I+-------+---+-----------+------------+----------+
(CONT)l IJSQLAB1 I ISQLEXE I ISQLCLS I I (CONT) I+----36+ -------------- +------------ +------------ -----50+
3-168
![Page 179: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/179.jpg)
PS 62034123130 September 1990
45+------+-
A CDKYUQI
-- + +---+----+
---- --- ----------- ---------------- -- +
(CONT)j ISQLTOC I jSQLOSQ I JSQLADR I I(CONT)I+----37+ - ------ ------ +------ ----- 51+
3-169
![Page 180: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/180.jpg)
PS 62034123130 September 1990
46+------
ICDNNEC I
---------- 1+.--+---+ +----+---- --------- ---------- ------
I(CONT)I ISQLTOC i ISQLOSQ I ISQL~ADR II(CONT)l+--- --------- +---------- +---------- ----- 52+
3-170
![Page 181: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/181.jpg)
PS 62034123130 September 1990
47+------------
ICDR=;~c I1~ - - ------------ ++-----------------------------+
----- +---+----- +---+----- +---+----+----
SQLSCA I ISQLBS1 I ISQLSCH I SQLSCC I I (CONT) I------------- +------------ +------------ +------------ +----53+
3-17 1
![Page 182: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/182.jpg)
PS 62034123130 September 1990
48
I CDPRE41I
+------------------------------------------------+--------------------
III II+-------+ ---- +------ ---- +------ ---- +------ -------- +
I (CONT) I ICDVTGK I CDMPIK I ICDlRIT I I (CONT) I+----39+ +---------- 54+ +---------- 55+ +---------- 56+ - -----57+
3-172
![Page 183: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/183.jpg)
PS 62034123130 September 1990
49+----------+ICDINEC I+--------.-+I-r -+----------------- -+-------------------------------------
+-----+ +---+ ---- + +---+ ---- + +---+ ---- + +---+ ---- +I (CONT) I ISQLAD1 I SQLFCH I CDACAQ I IERRPRO I+---- 40+ - ---------- +---------- +------- 58+ ---------- +
3-173
![Page 184: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/184.jpg)
PS 62034123130 September 1990
50+------------
ICDPTEC I+-------------------------+------------------------------+
I I+-------+---+-----------+-----------+-----------+---
I(CONT)l IRPTERR I ISQLAD1 I ISQLFCH I JERRPRO I-----44+ +------------- +------------ +------------ +------------
3-174
![Page 185: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/185.jpg)
PS 62034123130 September 1990
51+------------
ICDKYUQI
+------------+-------------+----------------------------+
II+-------+---+-----------+------------+------ -----
(CN)IQA1I I SLX I ILS j I OT-------- +------------ ------------- +------------ --------
3-175
![Page 186: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/186.jpg)
PS 62034123130 September 1990
52+------------
ICDNNEC II- - -+-------------+------------+----------------+
II+-------+----+----+ +---+-----+ +---+-----+ -----
I(CONT)I ISQLAB1 I SQLEXE I ISQLAD1 I I(CONT)l----- 46+ -------------- +------------ +------------ ----- 60+
3-176
![Page 187: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/187.jpg)
PS 62034123130 September 1990
53+------------
jCDRCTG I+--------.-+I
-----------------------------------------------
1 I I I I4+--+---+ +-------+ +-------+ +-------+ +--+---+
I(CONT)l ISQLTFL I ISQLOPN I ISQLOSQ I I(CONT)I+----47+ - ----------+ ---------- +---------- +---- 61+
3-177
![Page 188: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/188.jpg)
PS 62034123130 September 1990
54+------------
ICDVTGK I
-r -+------------+------------------------------++------------+----------+------------+----------+
------------- +------------ +------------ +------------ ---- 62+-
3-178
![Page 189: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/189.jpg)
PS 62034123130 September 1990
55+------------
ICDMPIK I-r -+-------------+-------------+----------------+I
+------ +---+----- +---+----- +---+----+ ---- +
ISQLSCA I ISQLBS1 I ISQLSCH I ISQLSCC I I (CONT) I+------------ +------------ +------------ +------------ +----63+
3-179
![Page 190: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/190.jpg)
PS 62034123130 September 1990
56----------
ICDIRIT I+---+------I
--------------------- +---------------------------
I I I I I------ + + --- +----+ +--------+ +---+--- + - -+ ISQLSCA I ISQLBS1 I ISQLSCH I jSQLSCC I I (CONT) I
---------- ---------- ---------- ---------- +----64+
3-180
![Page 191: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/191.jpg)
PS 62034123130 September 1990
57
CDPRE41
+--------------------------+------------------ -+------------------
------- -------- --- +----- ---- +----- --------
I(CONT)I ICDCRIT I ICDJUV I ICDAUC I I(CONT)I+----48+ +------------- ---- +----- +----------- -----65+
IRPTERRI+------------
3-181
![Page 192: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/192.jpg)
PS 62034123130 September 1990
58+------------
fCDACAQ I
+------------------------+-----------------------+--------------------
II I II-------+ ---- +----- ---- +------ ---- +----- ---- +------
ICDPRE5 I CDCMD I ICDMQAL I ICDPBL I IERRPRO------------- +------- 20+ - ----------- 2+ +----------2+ +-------------
3-182
![Page 193: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/193.jpg)
PS 62034123130 September 1990
60+------------
ICDNNEC I
------------------------------------------------
+--+I---- ---- +I----+ +---+I----+ +---+I----- +---+I----+
I(CONT) I SQLFCH I IRPTERR I ISQLCLS I IERRPRO 1+----52+ -------------- +------------ +------------ +----------
3-18 4
![Page 194: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/194.jpg)
PS 62034123130 September 1990
61+------------
ICDRCTG I---------------- +
S+------------------------------ -------
I(CONT)i ISQLADR I ISQTLAB1 I ISQLEXE I I(CONT)I+----53+ - ------ -------------------- +---- 67+
3-185
![Page 195: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/195.jpg)
PS 62034123130 September 1990
62+------------
ICDVTGK II- - +-------------+-----------------------------I
I+----- +---+-----+ +---+-----+ +---+-----+ ---- +
I(CONT)l jSQLTFL I ISQLOPN I ISQLOSQ I I(CONT)i+----54 -------------- ---------+ ---------- ----- 68+
3-186
![Page 196: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/196.jpg)
PS 62034123130 September 1990
63+------------
ICDMPIK I
It+-- ---------------- --- --- --- -- ---- +-----------+------ -- -- -
l(CONT) I SQLTOC I SQLOSQ I JSQLADR I I(CONT)I+----55+ -------------- +------------ +------------ ----- 69+
3-187
![Page 197: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/197.jpg)
PS 62034123230 September 1990
64+------------
ICD1RIT I
------- +------------- -+------------------------------------
I------ +----+I----+ +---+I----+ +---+I----+ +--+I---+
l(CONT)I ISQLTFL I ISQLOPN I ISQLOSQ I I(CONT)I+----56+ -------------- +------------ +------------ -----70+
3-188
![Page 198: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/198.jpg)
PS 62034123130 September 1990
65
If I CDPRE41
1-----------------------------------------+--------------+-------- ---------- ---------- --------- --------
I(CONT)I ICDTGVW I jCD2RIT I (CDERC I I(CONT)I+----57 ---------- 71+ +---------- +----------- +----72+--- ---------------- +-----------------------+--------------
jSQLSCA I ISQLBS1 I ISQLSCH I ISQLSCC I I(CONT)I+------------ ------------- ------------- +------------+ ----- 73+
3-189
![Page 199: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/199.jpg)
PS 62034123130 September 1990
66+------------
ICDKYUQI1~- - ------------ ++----------------------------1
I------- + +------- +-------- +-----------
I (CONT)l I CDCMD I JCDMQAL I ICDPBL I IERRPRO I+----59+ --------- 20+ ------------ 2+ ---------- 2+ -------------
3-190
![Page 200: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/200.jpg)
PS 62034123130 September 1990
67+------------
ICDRCTG I7-----------------------------------------
I+----- +---+----- +---+----- +---+--+
I(CONT)I ISQLAD1 I ISQLFCH I JERRPRO+---- ------------- +------------ +------------
3-19 1
![Page 201: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/201.jpg)
PS 62034123130 September 1990
68+------------
ICDVTGK IA
------- +------------- ------------------------------
+-------+ ---- +------ ---- +------ ---- +------ --------
I(CONT)I ISQLADR I ISQLAB1 I ISQLEXE I I(CONT)I+----62+ -------------- ------------- ------------- -----74+
3-192
![Page 202: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/202.jpg)
PS 62034123]30 September 199cQ
69+------------
rql ICDMPIK I-r -+-------------+-----------------------------+I
------------- +---+-----+ +---+-----+ -----
l(CONT)I ISQLAB1 I ISQLEXE I ISQLCLS I I(CONT)i+----63+ -------------- ------------- +------------ -----75+
3-193
![Page 203: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/203.jpg)
PS 62034123130 September 1990
70
~jCD1RIT I
~1- -- ------------- +-----------------------------+
+----- +---+-----+ +---+-----+ +---+----+ -+ U--
I(CONT)I JSQLADR I ISQLAB1 I ISQLEXE I I(CONT)l+----64 -------------- +------------ +------------ -----76+
3-194
![Page 204: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/204.jpg)
PS 62034123130 September 1990
71+------------
Jlr jCDTGVW I+-----------
------ ------------------- + -----------
ISQLSCA I ISQLBS1 I ISQLSCH I ISQLSCC I I (CONT) I------------- +------------ +------------ ------------- +----77+
3-195
![Page 205: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/205.jpg)
PS 62034123130 September 1990
72
CDPRE41
------------------------------------------------
I I-+.............I I I+-------+ ---- +------ ---- +------ ---- +------ ---- +------
I (CONT)l I CDASEL I ICDELIS I ICD2SEL I jCDZDEL 1+----65+ -------------- +------------ +------------ +------------
3-196
![Page 206: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/206.jpg)
PS 62034123130 September 1990
73+------------
4 ICD2RIT 14'- - ------------ +-----------+---------------+
II----- +---+----- +---+----+ +---+-----+ ---- +
I(CONT)I ISQLTOC I JSQLOSQ I JSQLADR I I(CONT)i+----65+ -------------- ------------- +------------ -----78+
3-197
![Page 207: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/207.jpg)
PS 62034123130 September 1990
74
+----------CDVTGKI
+-------------------------+------------4--------------+
I I-------- +---+-----------+-----------+-----------+--+
I (CONT)l I SQTLAD1 I fSQLFCH I IRPTERR I JERRPRO I+----68+ - ------------- +------------ +------------ +------------
3-198
![Page 208: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/208.jpg)
PS 62034123130 September 1990
75+------------
/. ICDMPIK I
+---- --------------------------------- +------------------
+--+I---- ---- +I----- +---+I----+ +----I+---- +---+I---+
I(CONT)I ISQTLAD1 IISQLFCH I ICDGTN I I(CONT)i+----69+ -------------- +------------ -------- 79+ - -----80+
3-199
![Page 209: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/209.jpg)
PS 62034123130 September 1990
76+------+-
ICDlRIT I
+------------ I---------- -------------
III II+-------+ ----- +----- ---- +------ ---- +------ ---- +------
(CONT)l ISQLAD1 I ISQLFCH I ICDACAQ I IERRPRO I+----70 -+-----+- +-----+- +----58+ +-----+-
3-200
![Page 210: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/210.jpg)
PS 62034123130 September 1990
79
ICDGTN I
----------------------------------- +. . . .
+-I --- + +---+I----+ +---+I----+ +---+I----+ +--+I---+
ISQLSCA I ISQLBS1 I ISQLSCH I ISQLSCC I I(CONT)I------- +---------- +---------- +---------- +----83+
3-203
![Page 211: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/211.jpg)
PS 62034123130 September 1990
80+------------
ICDMPIK 1I11~-- ++---------------- +
II I+-------+ ---- +------ ---- +------lo
I(CONT)I IRPTERR IJERRPRO 1+----75+ -------------- ------------
3-2 04
![Page 212: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/212.jpg)
PS 62,-14123130 Septemb :1990
81+------------
C ICDTGVW I
+-------------------------+------------------- --- +--------------------
+-------- ---------- + ----- -------- +------
I(CONT)I ISQLAB1 I ISQLEXE I ISQLCLS I l(CONT)I+----77+ - ------------- ------------- +------------ -----84+
3-205
![Page 213: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/213.jpg)
PS 62034123130 September 1990
82+------------
ICD2RIT I+------------+-------------+----------------------------+
II I II+-------+ ---- +------ ---- +-----+ ---- +------ -------- +
I (CONT)l J SQLAD1 I ISQLFCH I ICDPRE5 I I(CONT) I+----78+ -------------- +------------ ------------- -----85+
3-206
![Page 214: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/214.jpg)
PS 62034123130 September 1990
83
rf ICDGTN I
I+-------+----------------------------------------
I(CONT)I ISQLTFL I ISQLOPN I ISQLOSQ I I(CONT)I+----79+ -------------- ------------- +------------ ----- 86+
3-2 07
![Page 215: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/215.jpg)
PS 62034123130 September 1990
84
----------JCDTGVWI
+----------+--------------+-----------------------+--------------
I I I I I--- ++------- ---------- +---------- ------ --- --------20 +---7
3-2 08
![Page 216: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/216.jpg)
PS 62034123130 September 1990
85+----------
ICD2RITI
-r -+--------------'-----------------+----------------+--+I---- +----+I---- +----+I----- +---+I---- +----+I----+
I (CONT)l ICDCMD I ICDMQAL I jCDPBL I JERRPRO I----- 82+ - ------- 20+ - -------- 2+ --------- 2+ -----------
3-2 09
![Page 217: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/217.jpg)
PS 62034123130 September 1990
86
ICDGTN I'I
---------------------------------------I--- I I-----+-------+ +---+------ +---------+ --------- + +------+-A
I(CONT)I JSQLADR IISQL-AB1 I ISQLEXE I I(CONT)l+----83+ -------------- +------------ +------------ -----88+
3-2 10
![Page 218: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/218.jpg)
PS 62034123130 September 1990
87+------------
ICDTGVW I+--------------- ---
------------------+-------+ ---------- ---- +----
I (CONT)l I CDATXL I IERRPRO 1+---'-84+ +---------- 39+ - -------------
3-2 11
![Page 219: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/219.jpg)
PS 62034123130 September 1990
88
CDGTNI
-r -+----------------- -+-------------------------------------
+--+I---- ---- +I----- +---+I----+ +---+I----+ +---+I----+
I(CONT)I ISQILAD1 I ISQLFCH I IRPTERR I IERRPRO I+---- +------------ +------------ +------------ ------------
3-2 12
![Page 220: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/220.jpg)
PS 62034123130 September 1990
CD1RIT ... 56 SQLFCHCD2NEC SQLOPNCD2RIT ... 65 SQLOSQCD2SEL SQLSCACDABVW SQLSCCCDACAL ... 29 SQLSCH
4L CDACAQ ... 58 SQLTFLCDASEL SQLTOCCDATXL ... 39CDAUCCDCATCDCMD .... .20CDCRITCDELISCDEMD .... 18CDEMDA ... 12CDERCCDGTN .... 79CDGTVW .... 4CDIDIUCDINEC ... .21CDJUV .... 57CDKYUQ ... 37CDMPIK ... 55CDMQAL .... 2CDNNEC ... 38CDPBL........ 2CDPDI .... 19CDPRE4....... 2CDPRE5CDPTEC ... 28CDRCNR .......3CDRCTG ... 47CDTGVW ..71C DUTX LCDVIEW ... 11CDVNV........ 1CDVTGK ... 54CDZDELERIRPRORPT ERRSQ LAB 1SQ LA DSQ LADRSQLBS1SQLC LSS QLEXE
3-2 13
![Page 221: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/221.jpg)
PS 62034123130 September 1990
3.11 Program Listings Comments
This information is contained in the Module Descriptions inSection 3.10.
3-214
![Page 222: INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Neutral … · INTEGRATED INFORMATION SUPPORT SYSTEM (IISS) Volume V -Common Data Model Subsystem Part 14 -Neutral Data Manipulation Language](https://reader030.vdocuments.us/reader030/viewer/2022041109/5f0cda9e7e708231d4377592/html5/thumbnails/222.jpg)
PS 62034123130 September 1990
SECTION 4
QUALITY ASSURANCE PROVISIONS
4.1 Introduction and Definitions
"Testing" is a systematic process that may be preplannedand explicitly stated. Test techniques and procedures may bedefined in advance, and a sequence of test steps may bespecified. "Debugging" is the process of isolation andcorrection of the cause of an error.
"Antibugging" is defined as the philosophy of writingprograms in such a way as to make bugs less likely to occur andwhen they do occur, to make them more noticeable to theproqrammer and the user. In other words, as much error checkingas is practical and possible in each routine should beperformed.
4.2 Computer Programming Test and Evaluation
The quality assurance provisions for test consists of thenormal testing techniques that are accomplished during theconstruction process. They consist of design and codewalk-throughs, unit testing, and integration testing. Thesetests are performed by the design team. Structured design,design walk-through and the incorporation of "antibugging"facilitate this testing by exposing and addressing problem areasbefore they become coded "bugs."
4-1