The “Guide through the manuals” section explains which manuals and which parts of the manuals contain the information required by the user. A glossary gives brief definitions of the technical terms used in the text.
In addition to using the table of contents, users can find answers to their queries either via the index or by referring to the running headers.
Guide through the manuals
The UDS/SQL database system is documented in five manuals:
UDS/SQL Design and Definition
UDS/SQL Application Programming
UDS/SQL Creation and Restructuring
UDS/SQL Database Operation
UDS/SQL Recovery, Information and Reorganization
Further manuals describing additional UDS/SQL products and functions are listed on "Structure of the UDS/SQL documentation".
For a basic introduction the user should refer to chapters 2 and 3 of the "Design and Definition" manual; these chapters describe
reasons for using databases
the CODASYL database model
the relational database model with regard to SQL
the difference between the models
the coexistence of the two database models in a UDS/SQL database
the characteristic features of UDS/SQL
How the manuals are used depends on the user’s previous knowledge and tasks. Table 1 serves as a guide to help users find their way through the manuals.
Examples
A user whose task it is to write COBOL DML programs should look up the column “COBOL/CALL DML Programming” under “User task” in the second line of table 1.
There, the following chapters of the "Design and Definition" manual are recommended:
General information | B = Basic information |
Schema DDL | D = Detailed information |
SSL | D = Detailed information |
Subschema DDL | L = Learning the functions |
In the same column the user can also see which chapters of the other manual are of use.
Database administrators who are in charge of database administration and operation will find the appropriate information under the column “Administration and Operation”.
Contents of the five | User task | |||||||
Design | COBOL/ | SQL | Creation | Administration | Working | Working | Working | |
Manual UDS/SQL Design and Definition | ||||||||
Preface | B | – | – | – | – | B | B | – |
General information | B | B | B | B | B | B | – | – |
Designing the database | B | – | – | – | – | – | – | – |
Schema DDL | L | D | – | L | L | – | – | – |
SSL | L | D | – | L | L | – | – | – |
Subschema DDL | L | L | – | L | L | – | – | – |
Relational schema | L | – | D | – | – | – | – | – |
Structure of pages | D | – | – | D | D | – | – | – |
Structure of records and tables | D | – | – | D | D | – | – | – |
Reference section | S | – | – | S | – | – | – | – |
Manual UDS/SQL Application Programming | ||||||||
Preface | – | B | – | – | – | B | B | – |
Overview | – | B | – | – | – | – | – | – |
Transaction concept | – | L | – | L | L | D | D | – |
Currency table | – | L | – | L | L | – | – | – |
DML functions | D | L | – | L | – | – | – | – |
Using DML | – | L | – | D | – | – | – | – |
COBOL DML reference section | – | L | – | – | – | – | – | – |
CALL DML reference section | – | L | – | – | – | – | – | – |
Testing DML functions | – | L | – | – | – | – | – | – |
Manual UDS/SQL Creation and Restructuring | ||||||||
Preface | – | – | – | B | – | B | B | – |
Overview | – | – | – | B | B | – | – | – |
Database creation | – | – | – | L | – | – | – | – |
Defining access rights | – | – | – | L | – | – | – | – |
Storing and unloading | D | – | – | L | – | D | – | – |
Restructuring the database | D | – | – | L | – | – | – | – |
Renaming database objects | D | – | – | L | – | – | – | – |
Database conversion | D | – | – | L | – | – | – | – |
Database conversion using | – | – | – | D | – | – | – | – |
Manual UDS/SQL Database Operation | ||||||||
Preface | – | – | – | – | B | B | B | – |
The database handler | – | – | – | – | L | – | – | D |
DBH load parameters | – | – | – | – | L | – | – | D |
Administration | – | – | – | – | L | – | – | D |
High availability | – | – | – | – | B | – | – | – |
Resource extension and reorganisation | D | – | – | – | B | – | – | – |
Saving and recovering a database | D | – | – | D | L | D | – | D |
Optimizing performance | – | – | – | – | D | – | – | D |
Using BS2000 functionality | – | – | – | – | D | – | – | – |
The SQL conversation | – | – | – | – | L | – | – | – |
UDSMON | – | – | – | – | D | – | – | – |
General functions of the | – | – | – | – | D | – | – | – |
Using IQS | – | – | – | L | D | – | D | – |
Using UDS-D | D | D | – | D | D | D | – | D |
Function codes of DML statements | – | D | – | – | D | – | – | – |
ManualUDS/SQL Recovery, Information and Reorganization | ||||||||
Preface | – | – | – | – | B | B | B | – |
Updating and reconstructing a | D | – | – | D | L | D | – | – |
Checking the consistency of a | – | – | – | – | L | – | – | – |
Output of database information | D | – | – | D | L | – | – | – |
Executing online services | D | – | – | D | L | – | – | – |
Database reorganization | D | – | – | D | L | – | – | – |
Controlling the reuse of | D | – | – | D | L | – | – | – |
Additional Manuals | ||||||||
UDS/SQL Messages | D | D | D | D | D | D | D | D |
UDS/SQL System | S | S | – | S | S | S | S | S |
IQS | – | – | – | D | D | – | L | – |
ADILOS | – | – | – | – | D | – | L | – |
KDBS | – | L 1 | – | D | – | – | – | – |
SQL for UDS/SQL | – | – | D | – | D | – | – | – |
Table 1: Guide through the manuals
1 only for COBOL-DML
B | provides basic information for users with no experience of UDS/SQL |
L | helps the user learn functions |
D | provides detailed information |
S | provides a reference to syntax rules for practical work with UDS/SQL |
Additional notes on the manuals
References to other manuals appear in abbreviated form. For example:
(see the "Application Programming" manual, CONNECT)
advises the user to look up CONNECT in the "Application Programming" manual. The complete titles of the manuals can be found under “Related publications“ at the back of the manual.
UDS/SQL Messages
This manual contains all messages output by UDS/SQL. The messages are sorted in ascending numerical order, or in alphabetical order for some utility routines.
UDS/SQL System Reference Guide
The UDS/SQL System Reference Guide gives an overview of the UDS/SQL functions and formats.
SQL for UDS/SQL Language Reference Manual
This manual describes the SQL DML language elements of UDS/SQL.
In addition to UDS/SQL-specific extensions, the language elements described include dynamic SQL as an essential extension of the SQL standard.