BPSQLSIA execution
/ADD-FILE-LINK LINK-NAME=DATABASE,FILE-NAME=STAFF.DBDIR
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL,
VERSION=02.8A00
/START-UDS-BPSQLSIA
***** START BPSQLSIA (UDS/SQL V2.8 0000 ) 2015-06-28 11:40:32
//PRINT-RELATIONAL-SCHEMAINFO SUBSCHEMA-NAME=STAFF-DB
//END
***** DIAGNOSTIC SUMMARY FOR SUBSCHEMA STAFF-DB
NO ERRORS
+++++ 4 WARNINGS
***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES : 11
***** NORMAL END BPSQLSIA (UDS/SQL V2.8 0000 ) 2015-06-28 11:40:33
DDL of the CODASYL subschema
The numbers shown are the numbers of the conversion rules and refer to the corresponding parts in the relational schema information.
SCHEMA PERS-DB.
AREA PERS-DB-REALM.
AREA TEMPO TEMPORARY.
1/2) --- RECORD NAME IS DEPARTMENT WITHIN PERS-DB-REALM.
3) -------- 02 NAME PIC X(30).
02 LOCATION PIC X(30).
02 EXTERN PIC X.
02 DEPARTMENT-MGR TYPE IS BIN 31.
RECORD NAME IS EMPLOYEE
15) --------- LOCATION MODE IS CALC USING PERSONNEL-NR
DUPLICATES ARE NOT ALLOWED
WITHIN PERS-DB-REALM
14) --------- SEARCH KEY IS M-NAME
USING CALC
DUPLICATES ARE ALLOWED
17) --------- SEARCH KEY IS P-CODE,CITY,STREET
USING INDEX
DUPLICATES ARE NOT ALLOWED.
03 E-NAME PIC X(30).
5) -------- 03 FIRSTNAME PIC X(30) OCCURS 5.
03 E-AGE TYPE IS BIN 15.
03 MARITAL-STATUS PIC X.
4) -------- 03 CHILDREN OCCURS 10.
04 C-NAME PIC X(30).
04 C-AGE TYPE IS BIN 15.
03 CUST-ADDRESS OCCURS 2.
04 P-CODE PIC X(5).
04 CITY PIC X(15).
04 STREET PIC X(30).
03 PERSONNEL-NO TYPE IS BIN 31.
03 OCCUPATION PIC X(10).
03 SALARY PIC S9(8)V9(2).
03 BONUSES PIC S9(8)V9(2).
03 MGR-NO TYPE IS BIN 31.
RECORD NAME IS PROJECT WITHIN PERS-DB-REALM.
02 PROJ-NAME PIC X(30).
02 BUDGET PIC S9(10)V9(2).
02 PROJ-MGR TYPE IS BIN 31.
9) ------ SET NAME IS DEPT-EMP
ORDER IS FIRST
OWNER IS DEPARTMENT.
10) ---- MEMBER IS EMPLOYEE
MANDATORY AUTOMATIC
SEARCH KEY IS MGR-NO
USING INDEX DUPLICATES NOT ALLOWED
19) ----------- SEARCH KEY IS OCCUPATION,SALARY
USING INDEX DUPLICATES NOT ALLOWED
SELECTION CURRENT.
SET NAME IS PROJ-EMP
ORDER IS FIRST
OWNER IS PROJECT.
MEMBER IS EMPLOYEE
13) ----------- OPTIONAL MANUAL
SELECTION CURRENT.
8) ------- SET NAME IS INT-FUND
ORDER IS FIRST
OWNER IS SYSTEM.
MEMBER IS PROJECT
12) ----------- OPTIONAL AUTOMATIC
SEARCH KEY IS PROJ-NAME
USING CALC DUPLICATES NOT ALLOWED.
SET NAME IS PROJ-EMP-2
ORDER IS FIRST
OWNER IS PROJECT.
MEMBER IS EMPLOYEE
11) ----------- MANDATORY MANUAL
SELECTION CURRENT.
SET NAME IS EXT-FUND
ORDER IS FIRST
OWNER IS SYSTEM.
MEMBER IS PROJECT
OPTIONAL MANUAL.
SET NAME IS SYS-EMP
ORDER IS FIRST
OWNER IS SYSTEM.
MEMBER IS EMPLOYEE
MANDATORY AUTOMATIC
16) ----------- SEARCH KEY SALARY
USING CALC DUPLICATES NOT ALLOWED
18) ----------- SEARCH KEY E-AGE,MARITAL-STATUS
USING INDEX DUPLICATES NOT ALLOWED.
Output of BPSQLSIA to SYSLST
The numbers shown are the numbers of the conversion rules and refer to the corresponding parts in the DDL.
INFORMATION ABOUT RELATIONAL SCHEMA STAFF_DB 1) --- TABLE DEPARTMENT
ATTRIBUTE TYPE NOT NULL DEFAULT ___________________________________________________________________________________ 2) --- DEPARTMENT_ INTEGER NOT NULL PRIMARY KEY SYSTEMDEFINED3) --- D_NAME CHARACTER ( 30) NOT NULL ' ' D_LOCATION CHARACTER ( 30) NOT NULL ' ' EXTERN CHARACTER ( 1) NOT NULL ' ' DEPARTMENT_MGR INTEGER NOT NULL 0 ___________________________________________________________________________________ TABLE EMPLOYEE ATTRIBUTE TYPE NOT NULL DEFAULT ___________________________________________________________________________________ E_NAME CHARACTER ( 30) NOT NULL ' ' 5) --- FIRSTNAME ( 5) CHARACTER ( 30) NOT NULL ' ' E_AGE SMALLINT NOT NULL 0 MARITAL_STATUS CHARACTER ( 1) NOT NULL ' ' 4) --- CHILDREN ( 10) STRUCTURE C_NAME CHARACTER ( 30) NOT NULL ' ' C_AGE SMALLINT NOT NULL 0 ADDRESS ( 2) STRUCTURE P_CODE CHARACTER ( 5) NOT NULL ' ' CITY CHARACTER ( 15) NOT NULL ' ' STREET CHARACTER ( 30) NOT NULL ' ' PERSONNEL_NO INTEGER NOT NULL 0 UNIQUE OCCUPATION CHARACTER ( 10) NOT NULL ' ' 16) --- SALARY NUMERIC (10, 2) NOT NULL 0 UNIQUE BONUSES NUMERIC (10, 2) NOT NULL 0 MGR_NO INTEGER NOT NULL 0 9/10) --- DEPT_EMP_ INTEGER NOT NULL REFERENCES DEPARTMENT13) --- PROJ_EMP_ INTEGER NULL REFERENCES PROJECT 11) --- PROJ_EMP_2_ INTEGER NOT NULL ON UPDATE NULL REFERENCES PROJECT __________________________________________________________________________________ 17) --- UNIQUE (P_CODE, CITY, STREET) UNIQUE (DEPT_EMP_, MGR_NO) 19) --- UNIQUE (DEPT_EMP_, OCCUPATION, SALARY) 18) --- UNIQUE (E_AGE, MARITAL_STATUS) INDEX TO BE USED BY SQL INDEX DEFINITION IN UDS ___________________________________________________________________________________ 15) --- INDEX (PERSONNEL_NO) WARNING 4018 *** INDEX CAN BE USED ONLY WITHIN 'IN PREDICATE' OR WITHIN 'COMPARISON PREDICATE' WITH 'EQUALS OPERATOR' 14) --- INDEX (E_NAME) WARNING 4018 *** INDEX CAN BE USED ONLY WITHIN 'IN PREDICATE' OR WITHIN 'COMPARISON PREDICATE' WITH 'EQUALS OPERATOR' INDEX (ADDRESS) INDEX (P_CODE, CITY, STREET) INDEX (DEPT_EMP_, MGR_NO) INDEX (DEPT_EMP_, OCCUPATION, SALARY) INDEX (SALARY) WARNING 4018 *** INDEX CAN BE USED ONLY WITHIN 'IN PREDICATE' OR WITHIN 'COMPARISON PREDICATE' WITH 'EQUALS OPERATOR' INDEX (E_AGE, MARITAL_STATUS) TABLE PROJECT ATTRIBUTE TYPE NOT NULL DEFAULT ___________________________________________________________________________________ PROJECT_ INTEGER NOT NULL PRIMARY KEY SYSTEMDEFINED PROJ_NAME CHARACTER ( 30) NOT NULL ' ' BUDGET NUMERIC (12, 2) NOT NULL 0 PROJ_MGR INTEGER NOT NULL 0 12) --- INT_FUND_ INTEGER NOT NULL ON INSERT REFERENCES SYSTEM EXT_FUND_ INTEGER NULL REFERENCES SYSTEM ___________________________________________________________________________________ UNIQUE (INT_FUND_, PROJ_NAME) INDEX TO BE USED BY SQL INDEX DEFINITION IN UDS ___________________________________________________________________________________ INDEX (INT_FUND_, PROJ_NAME) WARNING 4018 *** INDEX CAN BE USED ONLY WITHIN 'IN PREDICATE' OR WITHIN 'COMPARISON PREDICATE' WITH 'EQUALS OPERATOR' TABLE SYSTEM ATTRIBUTE TYPE NOT NULL DEFAULT ___________________________________________________________________________________ 8) --- SYSTEM_ INTEGER NOT NULL 0 PRIMARY KEY SYSTEMDEFINED ___________________________________________________________________________________ *** SHORT INFORMATION ABOUT RELATIONAL SCHEMA RELATIONAL SCHEMA CAN BE PROCESSED WITH SQL *** SHORT INFORMATION ABOUT TABLES RET = Y : TABLE CAN BE PROCESSED WITH SQL = N : TABLE CANNOT BE PROCESSED WITH SQL INS = N : NO INSERT ALLOWED ON TABLE UPD = N : NO UPDATE ALLOWED ON TABLE ATR = Y : ALL ATTRIBUTES CAN BE PROCESSED WITH SQL TABLE RET INS UPD ATR _____________________________________________ DEPARTMENT Y Y Y Y EMPLOYEE Y Y Y Y PROJECT Y Y Y Y ***** DIAGNOSTIC SUMMARY FOR SUBSCHEMA STAFF-DB NO ERRORS +++++ 4 WARNINGS ***** END OF DIAGNOSTIC SUMMARY