Ca Idms Database Design Guide
CA IDMS Release 18.5, 2nd Edition (Public) Bookshelf Enter search term CA IDMS Release 18.5 CA IDMS Release 18.5, 2nd Edition (Public) Welcome to the CA IDMS Release 18.5 bookshelf. All manuals are 1st edition from May 2013 unless indicated otherwise.: Use search on this bookshelf to search the product documentation provided in the bookshelf. Go to the CA Support website to search multiple sources including product documentation for the information you need.
Note: manuals without an active PDF/HTML download link can be accessed from the (logging on using an approved company site ID required). Release Information Release 18.5.00 Release Notes, 2nd Edition Documentation Changes. Post Release Documentation Updates. Product Documentation - Alphabetical Select a letter to view available documentation in alphabetical order ( / ): F H K Q W X Y Z. D Database Administration Guide 2nd ed. July 2014 Database Design Guide 2nd ed. July 2014 Database Log Analyzer Option User Guide 2nd ed.
July 2014 DB Analyzer User Guide DB Audit User Guide DB Database Reorg Option User Guide 2nd ed. July 2014 DBOMP Transparency User Guide DC Sort User Guide DDS Design and Operations Guide Dictionary Diagram. Dictionary DSECT Reference Guide 2nd ed. July 2014 Dictionary Loader User Guide Dictionary Migrator User Guide 2nd ed. July 2014 Dictionary Module Editor User Guide Dictionary Query Facility User Guide Dictionary Structure Reference Guide DLI Transparency User Guide DML Online User Guide 2nd ed.
July 2014 DML Reference Guide for Assembler 2nd ed. July 2014 DML Reference Guide for COBOL 3rd ed. July 2014 DML Reference Guide for PL/I 3rd ed. July 2014 DSECT Reference Guide 2nd ed. CA IDMS/DB, CA IDMS/DC, and Related Products Dictionary Loader User Guide IDMS ASF User Guide 2nd ed.
Ca Idms Database Design Guidelines
July 2014 Best Practices Guide Callable Services Guide 2nd ed. July 2014 Common Facilities Guide 2nd ed. July 2014 Conversion Guide Database Administration Guide 2nd ed. July 2014 Database Design Guide 2nd ed.
July 2014 DDS Design and Operations Guide Dictionary Diagram. Dictionary DSECT Reference Guide 2nd ed.
July 2014 Dictionary Structure Reference Guide DML Reference Guide—Assembler 2nd ed. July 2014 DML Reference Guide—COBOL 3rd ed.
July 2014 DML Reference Guide—PL/I 3rd ed. July 2014 DSECT Reference Guide 2nd ed. July 2014 Glossary 2nd ed. March 2014 IDD DDDL Reference Guide 2nd ed. July 2014 Installation and Maintenance Guide—z/OS 2nd ed. July 2013 Logical Record Facility Guide Mapping Facility Guide Messages and Codes Guide—Volume 1 2nd ed. July 2014 Messages and Codes Guide—Volume 2 2nd ed.
July 2014 Messages and Codes Guide—Volume 3 2nd ed. July 2014 Messages and Codes Guide—Volume 4 2nd ed.
July 2014 Navigational DML Programming Guide 2nd ed. July 2013 Online Debugger Guide Release Notes 18.5.00 2nd ed. July 2014 Reports Guide Security Administration Guide 2nd ed. March 2014 System Generation Guide 2nd ed. July 2014 System Operations Guide 2nd ed. July 2014 System Tasks and Operator Commands Guide 2nd ed. July 2014 Utilities Guide 2nd ed.
July 2041 Performance Monitor User Guide System Administration Guide 2nd ed. July 2014 Presspack User Guide. CA IDMS Tools ADS Alive User Guide ADS Trace User Guide IDMS DB Analyzer User Guide DB Audit User Guide DB Reorg User Guide 2nd ed.
July 2014 DC Sort User Guide Dictionary Migrator User Guide 2nd ed. July 2014 Dictionary Module Editor User Guide Dictionary Query Facility User Guide DML Online User Guide 2nd ed. July 2014 Enforcer User Guide Extractor User Guide Journal Analyzer User Guide Log Analyzer User Guide Masterkey User Guide Online Log Display User Guide 2nd ed.
July 2014 SASO User Guide Schema Mapper User Guide Task Analyzer User Guide 2nd ed. CA IDMS Release Notes and Release Summaries Release 18.5.00 Release Notes 2nd ed. July 2014 Version 18.0.00 Release Notes 2nd ed. July 2014 r17 SP1 Release Summary r17 Release Summary. r16 SP4 Release Summary.
r16 SP3 Release Summary. r16 SP2 Release Summary. r16 SP1 Release Summary. r16 Release Summary.
Ca Idms Database
r15 Release Features Guide. r14.1 Release Features Summary.
r14 Release Features Guide. r12 Release Features Summary. Release Summary documents older than r17 SP1 are only available in PDF format. Systems Programmer / Systems DBA Scenarios. How to Expand the Employee Demo Database With Mixed Page Group Index Sets ( / ). How to Use SQL Web Connect ( / ) Guides IDMS Analyzer User Guide Best Practices Guide Callable Services Guide 2nd ed. July 2014 Common Facilities Guide 2nd ed.
July 2014 Conversion Guide Database Administration Guide 2nd ed. July 2014 Database Log Analyzer Option User Guide DB Database Reorg Option User Guide 2nd ed. July 2014 DC Sort User Guide DDS Design and Operations Guide Dictionary Diagram. Dictionary DSECT Reference Guide 2nd ed. July 2014 Dictionary Migrator User Guide 2nd ed.
July 2014 Dictionary Module Editor User Guide Dictionary Query Facility User Guide Dictionary Structure Reference Guide DSECT Reference Guide 2nd ed. July 2014 Glossary 2nd ed. March 2014 IDD DDDL Reference Guide 2nd ed. July 2014 Installation and Maintenance Guide for z/OS 3rd ed. July 2014 Log Analyzer User Guide Messages and Codes Guide—Volume 1 2nd ed. July 2014 Messages and Codes Guide—Volume 2 2nd ed. July 2014 Messages and Codes Guide—Volume 3 2nd ed.
July 2014 Messages and Codes Guide—Volume 4 2nd ed. July 2014 Online Log Display User Guide 2nd ed. July 2014 Reports Guide SASO User Guide Security Administration Guide 2nd ed. March 2014 System Generation Guide 2nd ed. July 2014 System Operations Guide 2nd ed. July 2014 System Tasks & Operator Commands Guide 2nd ed. July 2014 Task Analyzer User Guide 2nd ed.
July 2014 Utilities Guide 2nd ed. July 2014 IDMS Server User Guide IDMS Transparency Option DBOMP User Guide TOTAL User Guide IDMS Visual DBA User Guide Performance Monitor System Administration Guide 2nd ed. July 2014 User Guide 2nd ed. Security Administrator Guides IDMS Dictionary DSECT Reference Guide 2nd ed.
July 2014 Messages and Codes Guide—Volume 1 2nd ed. July 2014 Messages and Codes Guide—Volume 2 2nd ed. July 2014 Messages and Codes Guide—Volume 3 2nd ed. July 2014 Messages and Codes Guide—Volume 4 2nd ed. July 2014 Online Log Display User Guide 2nd ed.
July 2014 Reports Guide Security Administration Guide 2nd ed. July 2014 System Operations Guide 2nd ed. July 2014 Utilities Guide 2nd ed. July 2014 IDMS Visual DBA User Guide Performance Monitor System Administration Guide 2nd ed. Application DBA Scenarios.
How to Expand the Employee Demo Database With Mixed Page Group Index Sets ( / ). How to Use SQL Web Connect ( / ) Guides ADS Application Design Guide DSECT Reference Guide 2nd ed.
July 2014 Reference Guide 2nd ed. July 2014 User Guide 2nd ed.
July 2014 ADS Alive User Guide ADS Batch User Guide ADS Trace User Guide Culprit for CA IDMS Messages and Codes Guide 2nd ed. July 2014 Reference Guide 2nd ed.
July 2014 User Guide 2nd ed. July 2014 User Modules Guide 2nd ed. July 2014 Dictionary Loader User Guide Endevor/DB Change Manager Administration Guide Batch Reference Guide Bridge Administrator Guide Concepts and Facilities Guide Messages and Codes Guide User Guide IDMS Analyzer User Guide ASF User Guide 2nd ed.
July 2014 Best Practices Guide Callable Services Guide 2nd ed. July 2014 Common Facilities Guide 2nd ed. July 2014 Conversion Guide Database Administration Guide 2nd ed. July 2014 Database Design Guide 2nd ed. July 2014 Database Log Analyzer Option User Guide 2nd ed. July 2014 DB Analyzer User Guide DB Audit User Guide DB Database Reorg Option User Guide 2nd ed. July 2014 DC Sort User Guide DDS Design and Operations Guide Dictionary Diagram.
Dictionary DSECT Reference Guide 2nd ed. July 2014 Dictionary Migrator User Guide 2nd ed. July 2014 Dictionary Module Editor User Guide Dictionary Query Facility User Guide Dictionary Structure Reference Guide DML Online User Guide 2nd ed. July 2014 DML Reference Guide for Assembler 2nd ed. July 2014 DML Reference Guide for COBOL 3rd ed.
July 2014 DML Reference Guide for PL/I 3rd ed. July 2014 DSECT Reference Guide 2nd ed. July 2014 Enforcer User Guide Extractor User Guide Glossary 2nd ed.
March 2014 IDD DDDL Reference Guide 2nd ed. July 2014 Journal Analyzer User Guide Log Analyzer User Guide Logical Record Facility Guide Mapping Facility Guide Masterkey User Guide Messages and Codes Guide—Volume 1 2nd ed. July 2014 Messages and Codes Guide—Volume 2 2nd ed. July 2014 Messages and Codes Guide—Volume 3 2nd ed.
July 2014 Messages and Codes Guide—Volume 4 2nd ed. July 2014 Navigational DML Programming Guide 2nd ed. July 2013 Online Debugger Guide Online Log Display User Guide 2nd ed. July 2014 Reports Guide SASO User Guide Schema Mapper User Guide Security Administration Guide 2nd ed. March 2014 System Generation Guide 2nd ed.
July 2014 System Operations Guide 2nd ed. July 2014 System Tasks & Operator Commands Guide 2nd ed. July 2014 Task Analyzer User Guide 2nd ed. July 2014 Utilities Guide 2nd ed. July 2014 IDMS OLQ Online Query User Guide IDMS Server User Guide IDMS SQL Programming Guide Quick Bridge User Guide Reference Guide 2nd ed. July 2014 Self-Training Guide IDMS Transparency Option DBOMP User Guide DLI User Guide TOTAL User Guide VSAM User Guide 2nd ed. July 2014 IDMS Visual DBA Visual DBA User Guide Performance Monitor System Administration Guide 2nd ed.
July 2014 User Guide 2nd ed. July 2014 Presspack User Guide. Application Developer Guides ADS Application Design Guide DSECT Reference Guide 2nd ed. July 2014 Reference Guide 2nd ed.
July 2014 User Guide ADS Alive User Guide ADS Batch User Guide ADS Trace User Guide Culprit for CA IDMS Messages and Codes Guide 2nd ed. July 2014 Reference Guide 2nd ed.
July 2014 User Guide 2nd ed. July 2014 User Modules Guide 2nd ed. July 2014 Dictionary Loader User Guide Endevor/DB Change Manager Administration Guide Batch Reference Guide Bridge Administrator Guide Concepts and Facilities Guide Messages and Codes Guide User Guide IDMS Analyzer User Guide ASF User Guide 2nd ed. July 2014 Callable Services Guide 2nd ed. July 2014 Common Facilities Guide 2nd ed. July 2014 Database Administration Guide 2nd ed. July 2014 Database Design Guide 2nd ed.
July 2014 DC Sort User Guide Dictionary Diagram. Dictionary DSECT Reference Guide 2nd ed. July 2014 Dictionary Migrator User Guide 2nd ed. July 2014 Dictionary Module Editor User Guide Dictionary Query Facility User Guide DML Online User Guide 2nd ed. July 2014 DML Reference Guide for Assembler 2nd ed.
July 2014 DML Reference Guide for COBOL 3rd ed. July 2014 DML Reference Guide for PL/I 3rd ed. July 2014 DSECT Reference Guide 2nd ed.
July 2014 Enforcer User Guide Extractor User Guide Glossary 2nd ed. March 2014 IDD DDDL Reference Guide 2nd ed. July 2014 Logical Record Facility Guide Mapping Facility Guide Masterkey User Guide Messages and Codes Guide—Volume 1 2nd ed. July 2014 Messages and Codes Guide—Volume 2 2nd ed. July 2014 Messages and Codes Guide—Volume 3 2nd ed. July 2014 Messages and Codes Guide—Volume 4 2nd ed.
July 2014 Navigational DML Programming Guide 2nd ed. July 2013 Online Debugger Guide Online Log Display User Guide 2nd ed. July 2014 Reports Guide SASO User Guide Schema Mapper User Guide Security Administration Guide 2nd ed. March 2014 System Tasks & Operator Commands Guide 2nd ed.
July 2014 Task Analyzer User Guide 2nd ed. July 2014 Utilities Guide 2nd ed. July 2014 IDMS OLQ Online Query Reference Guide User Guide IDMS Server User Guide IDMS SQL Programming Guide Quick Bridge User Guide Reference Guide 2nd ed. July 2014 Self-Training Guide IDMS Transparency Option DBOMP User Guide DLI User Guide TOTAL User Guide VSAM User Guide 2nd ed. July 2014 IDMS Visual DBA User Guide Performance Monitor System Administration Guide 2nd ed. July 2014 User Guide 2nd ed.
July 2014 Presspack User Guide. Web Developer / End User Guides Culprit for CA IDMS Messages and Codes Guide 2nd ed. July 2014 Reference Guide 2nd ed. July 2014 User Guide 2nd ed.
July 2014 User Modules Guide 2nd ed. July 2014 IDMS Glossary 2nd ed.
March 2014 Messages and Codes Guide—Volume 1 2nd ed. July 2014 Messages and Codes Guide—Volume 2 2nd ed. July 2014 Messages and Codes Guide—Volume 3 2nd ed.
July 2014 Messages and Codes Guide—Volume 4 2nd ed. July 2014 Online Log Display User Guide 2nd ed.
July 2014 Reports Guide IDMS OLQ Online Query Reference Guide User Guide IDMS SQL Programming Guide Quick Bridge User Guide Reference Guide 2nd ed. July 2014 Self-Training Guide IDMS Visual DBA Visual DBA User Guide Scenarios Select a link to view available scenarios by user role:.
The SCHEMA statements identify the schema as a whole, and establish schema currency. In addition, SCHEMA statements can:. Add, modify, delete, display, or punch a schema description. Establish security for the schema. Authorize users to issue specific verbs against the schema Syntax order ADD/MODIFY syntax is presented first, followed by DELETE syntax. DISPLAY/PUNCH syntax is presented last. Expansion variables Diagrams for expansion variables (indicated by underscore and italics) are shown at the end of the current syntax diagram.
Expansions for common clauses are handled in a separate section, and those expansions are referenced in the parameter description. Syntax Syntax: ADD/MODIFY SCHEMA statement.
Note: Expanded syntax for user-specification is presented in Section13, 'Parameter Expansions”. schema DEScription is description-text Optionally specifies a name that is more descriptive than the 8-character schema name required by CA IDMS/DB, but can be used to store any type of information.
This clause is purely documentational. Description-text is a 1- to 40-character alphanumeric field; if it contains spaces or delimiters, it must be enclosed in site-standard quotes.
MEMo DATe is mm/dd/yy Specifies any date the user wishes to supply; it is purely documentational. Note that the time and date of schema creation and last revision are maintained automatically, apart from MEMO DATE, by the schema compiler. ASSign RECord IDS from record-id-number Specifies the number that the schema compiler will use as a base for numbering schema records. Record-id-number must be an unsigned integer in the range 10 through 9999; it defaults to 1001. Record-id-number is assigned to the first record in the schema that specifies RECORD ID IS AUTO. The compiler assigns record-id-number to that record. Note: For more information on assigning IDs for subsequent records, see the description of RECORD ID IS AUTO under 14.4, “RECORD Statement”.
DERived from SCHema is old-schema-name Associates the current schema with another schema ( old-schema-name). This clause is purely informational.
DERived from SCHema is NULl Dissolves such an association between the current schema and another. It is purely documentational.
INClude USEr is user-id Associates a user with the schema description. User-id must be the name of a user as defined in the dictionary. user-options-specification Specifies options available to a user associated with the schema.
Note: Expanded syntax for user-options-specification is presented in Section13, 'Parameter Expansions”. EXClude USEr is user-id Disassociates a user from the current schema.
User-id must be the ID of a user as defined in the dictionary. PUBlic ACCess is allowed for For the current schema and its components, specifies which operations are available for public access (that is, to all users who can sign on to the schema compiler). When coded, the keyword ALLOWED can be abbreviated to no fewer than 4 characters (ALLO). DELete Allows all users to DELETE, DISPLAY, and PUNCH the schema and its components. DISplay Allows all users to DISPLAY and PUNCH the schema and its components. MODify Allows all users to MODIFY, DISPLAY, and PUNCH the schema and its components.
UPDate Allows all users to ADD, MODIFY, DELETE, DISPLAY, and PUNCH the schema and its components. Unlike ALL, UPDATE does not allow users to change the schema's PUBLIC ACCESS specification. ALL Allows all users to ADD, MODIFY, DELETE, DISPLAY, and PUNCH the schema and its components. Additionally, ALL allows users to change the schema's PUBLIC ACCESS specification, thus enabling them to change security for the schema. ALL is the default. NONe Prohibits all users, except those explicitly associated with the schema, from accessing it in any way. INClude class-name is attribute-name Classifies the schema for documentational purposes by associating an attribute with the schema.
INCLUDE is the default. Class-name must be the name of a class as defined in the dictionary through the IDD DDDL compiler. If the dictionary entry for the class specifies that attributes must be added manually, attribute-name must be the name of an attribute already associated with class-name; if not, attribute-name can be any 1- to 40-character value, enclosed in site-standard quotes if it contains spaces or delimiters. Note: See the CA IDMS IDD DDDL Reference section for instruction in defining classes and attributes.
Ca Idms Database Manual
TEXT is user-text Supplies additional documentation of the assignment of a specific attribute to the schema. User-text is 1 to 40 characters of text; if it contains spaces or delimiters, it must be enclosed in site-standard quotes. EXClude class-name is attribute-name Disassociates an attribute from the schema. Class-name must be the name of a class for which an attribute is already associated with the schema; attribute-name names the attribute to be disassociated from the schema.
INClude/EXClude USER DEFINED COMMENT is comment-key Identifies a type of comment to be associated with (INCLUDE) or disassociated from (EXCLUDE) the schema. INCLUDE is the default. Comment-key must identify an existing user-defined comment type.
Values that contain embedded blanks or special characters or that duplicate a keyword from the DDL syntax must be enclosed in site-standard quote characters. Comment text is assigned to the comment-key using the COMMENTS clause.
COMments/ comment-key is comment-text/NULl Updates or removes schema comments. Comment-key is the value assigned in the USER DEFINED COMMENTS clause of the IDD DDDL MODIFY ENTITY statement. NULl removes comment text from the current schema. Note: Coding rules for comment-text are presented in 10.5.4, “Coding Comment Text”. ALL COMment TYPes Displays and punches all information from the categories COMMENTS, CULPRIT HEADERS, and OLQ HEADERS.
AREas Displays and punches all areas in the schema. ATTributes Displays and punches all attributes, and their respective classes, associated with the schema. COMments Displays and punches all comments associated with the schema through the COMMENTS clause of the ADD or MODIFY SCHEMA statement; when RECORDS and ELEMENTS are also specified, all COMMENTS associated with the record elements. CULprit headers When RECORDS and ELEMENTS are also specified, displays and punches all CULPRIT HEADERS specified for the record elements. DETails Displays and punches information specified previously in the following clauses:. SCHEMA DESCRIPTION.
MEMO DATE. ASSIGN RECORD IDS FROM. PUBLIC ACCESS. ELements When RECORDS is also specified, displays and punches all elements contained within the records. HIStory Displays and punches creation and revision information:.
Creation - The date and time the schema was added to the dictionary and the user who added it (also known as the prepared-by user). Revision - The date and time the schema was last modified and the user who modified it (also known as the revised-by user). OLQ headers When RECORDS and ELEMENTS are also specified, displays and punches all OLQ HEADERS specified for the record elements.
RECords Displays and punches all records in the schema, without their associated elements. SCHemas Displays and punches the schema associated with the current schema through the DERIVED FROM SCHEMA clause. SETs Displays and punches all sets in the schema. SHAred structures When RECORDS and DETAILS are also specified, WITH SHARED STRUCTURES displays the SHARE STRUCTURE clause of the record definition as syntax, and the record's elements as comments.
WITHOUT SHARED STRUCTURES displays a clause, USES STRUCTURE OF RECORD, as comments, and the record's elements as syntax. SUBSChemas Displays and punches all subschemas associated with the schema. SYNonyms When RECORDS is also specified, displays and punches the record synonyms associated with the schema; when RECORDS and ELEMENTS are also specified, displays and punches the record and element synonyms associated with the schema. USErs Displays and punches all users associated with the schema. ALL Displays and punches the entire schema description. NONe Displays and punches only the schema name and version number.
Usage Effect of ADD on Schema ADD creates a new schema description in the dictionary. Default values established through the SET OPTIONS statement can be used to supplement the user-supplied description. ADD also sets the schema's status to IN ERROR. A VALIDATE statement must set the status to VALID before a subschema or CA IDMS/DB utility can reference the schema. Effect of MODIFY on Schema MODIFY modifies an existing schema description in the data dictionary.
This verb also sets the schema's status to IN ERROR. A VALIDATE statement must set the status to VALID before a subschema or CA IDMS/DB utility can reference the schema. Effect of DELETE on Schema DELETE deletes an existing schema description and its associated subschema descriptions from the dictionary. If the SET OPTIONS statement specifies DELETE IS ON, the schema compiler also:. Logically deletes version 1 of all subschema load modules associated with the schema from the load area of the dictionary (load modules qualified by another version number must be explicitly deleted).
Automatically erases version 1 of any PROG-051 dictionary record occurrence associated with the subschema load module, provided the record was built by the subschema compiler and is not related to any other entity type in the dictionary. SCHEMA statement defaults The schema compiler defaults to supply this information on the schema:. Version-number defaults to the current session option for new versions. The record ID assignment begins with 1001.
ADD interpreted as MODIFY If, on an ADD operation, a schema of the same name and version already exists in the dictionary, the action taken by the schema compiler varies depending on the session option for DEFAULT:. If DEFAULT IS ON was specified, the schema compiler interprets the ADD as a MODIFY for the named schema. If DEFAULT IS OFF was specified, the schema compiler issues an error message and terminates processing of the ADD SCHEMA statement. Note that, in this case, schema currency will be null for subsequent statements. Security enforcement If either authority for SCHEMA is on or the schema being operated on is secured in the dictionary, the user issuing the schema statement must hold the necessary authority to perform the operation. The user issuing the statement is established by:.
user-specification in the SCHEMA statement. user-specification in the SET OPTIONS statement. The user identified in a compiler SIGNON statement. The user known to the runtime environment in which the compiler is executing If SIGNON OVERRIDE is not allowed, the user is always the one known to the runtime environment. USER DEFINED COMMENTS clause To associate a user-defined comment with a schema:. Specify a comment-key in the USER DEFINED COMMENTS clause. Associate comment-text with the key in the COMMENTS clause If a COMMENTS clause appears in a MODIFY statement, the compiler edits or removes existing comment text.
To remove user-defined comments:. Specify NULL in a COMMENTS clause. Specify EXCLUDE in a USER DEFINED COMMENTS clause Use DISPLAY ALL to list all schema names To list the names of all schemas, issue a DISPLAY ALL statement. Examples Minimum SCHEMA statement The following example supplies the minimum SCHEMA statement required for the purpose of later establishing a functional database.