Compilation of the storage structure description is optional; if SSL is not used, UDS/SQL assumes default values. If an SSL description has been written, it can be compiled by the SSL compiler.
The SSL compiler analyzes the storage structure description and modifies the entries in the DBCOM to match the SSL.
When required, the SSL compiler automatically extends the DBDIR and DBCOM of the database being processed or the DBTTs of the record types in the DBDIR and DBCOM. For details,
please refer to the "Database Operation" manual, Automatic realm extension by means of utility routines.
At startup the SSL compiler takes into account any assigned UDS/SQL pubset declaration (see the "Database Operation" manual, Pubset declaration job variable). Faulty assignment leads to the program aborting.
During execution the SSL compiler uses the linked-in DBH.
Figure 10: System environment for SSL compilation
SSL compiler statements
The statements for the SSL compiler are given in the Table of compiler statements(see table 12 of a chapter "Compiling the Schema DDL").
Command sequence for compiling the SSL
It is assumed for the command sequence described here that UDS/SQL was installed with IMON (see section "START commands for the UDS/SQL programs").
|
02 | The version-dependent module of the linked-in DBH of the relevant version is loaded dynamically (see the section entitled "Compiling, linking and loading UDS/SQL-TIAM appliction programs" in the "Application Programming" manual). |
03 04 | The UDS/SQL utility routine can also be started with the alias SSL. The individual statements can be entered in one line if they are separated by commas or blanks. |
Example
/ADD-FILE-LINK LINK-NAME=DATABASE,FILE-NAME=TRAVEL.DBDIR
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL, VERSION=02.9B00
/START-UDS-SSL
***** START SSLCOMP (UDS/SQL V2.9 1801 ) 2019-01-29 09:26:54
* SSLCOMP: INPUT SYSTEMPARAMETERS
SORCLIST IS YES
SOURCE IS 'S.TRAVEL.SSL'
END
* SSLCOMP: READ SSL-SCHEMA
% UDS0215 UDS STARTING UDS/SQL V2.9 (LINKED-IN), DATE=2019-01-29 (ILL2038,09:26:54/4TE7)
% UDS0746 UDS PUBSET DECLARATION (CURRENT) FOLLOWS (ILL1746,09:26:54/4TE7)
4TE7:UDS-PUBSET-JV: :IUDS:$XXXXXXXX.PUBSDECL.PUBS
4TE7:PUBSETS: IUDS
4TE7:DEFAULT PUBSET: IUDS
4TE7: ------------------------------------------
* SSLCOMP: START SSL-PHASE
* SSLCOMP: CHECK SSL RULES
* SSLCOMP: SEMANTIC TEST
* SSLCOMP: ERROR DIAGNOSTIC
* SSLCOMP: NO ERRORS DETECTED
% UDS0758 NUMBER OF DML-STATEMENTS AND I/O COUNTERS PER DATABASE (ILL1758,09:26:55/4TE7)
4TE7: DATABASE NAME DMLS LOG READ PHYS READ LOG WRITE PHYS WRITE
4TE7: -------------------------------------------------------------------
4TE7: TRAVEL 354 563 62 57 27
% UDS0213 UDS NORMAL SYSTEM TERMINATION WITH *************354 DML-STATEMENTS 2019-01-29
(ILLY033,09:26:55/4TE7)
***** DIAGNOSTIC SUMMARY FOR SSL - SCHEMA
NO ERRORS
NO WARNINGS
***** END OF DIAGNOSTIC SUMMARY
***** NORMAL END SSLCOMP (UDS/SQL V2.9 1801 ) 2019-01-29 09:26:55