The main changes introduced in UDS/SQL V2.9 in comparison with Version V2.8 are listed in table 2 below together with the manuals and the sections in which the changes are described. If a specific topic has been dealt with in more than one manual, the manual in which a detailed description appears is listed first. The following codes are used in the “Manual” column for the individual manuals involved:
DES | Design and Definition | DBO | Database Operation |
APP | Application Programming | RIR | Recovery, Information and Reorganization |
CRE | Creation and Restructuring | MSG | Messages |
Topic | Manual | Chapter |
Changes in V2.9A | ||
FIND-/FETCH-7 with DESCENDING KEY: Suspension of the restriction | ||
The restriction for DESCENDING KEY is omitted | APP | 7 |
Record references in COBOL programs: | ||
The new DDL-statement GENERATE-REC-REF generates a data field and condition names for the access to record references | CRE | 3 |
Changing settings of ALOG files while the database is in use | ||
New DAL command DISPLAY ALOG shows ALOG settings | DBO | 4 |
New DAL commands MODIFY ALOG/MODIFY ALOG-RES and MODIFY-ALOG-SIZE change ALOG settings | DBO | 4 |
Change of the restrictions for the UDS Online Utility | ||
WAIT-FOR-TRANSACTION offers the possibility to wait until the locked source page is released by the locking transaction | RIR | 8 |
With SET-RELOCATE-PARAMETERS a behaviour for the case that pages are locked can be specified also for *INDEX-LEVEL-TABLE-PAGES (CLASH-HANDLING) | RIR | 8 |
BRENAME with after-image logging: The function “Renaming database objects (BRENAME, BALTER)” can also be executed when After Image Logging is activated. Thus logging gaps can be avoided | ||
New behaviour in a renaming cycle | CRE | 7 |
After a renaming process a data base update can be executed | RIR | 2 |
Specifying the size for DBTT extensions | ||
New operand EXT of the DAL command ACT DBTT-INCR | DBO | 4 |
The BSTATUS output additionally contains the value of the EXT operand | RIR | 6 |
New data type FIXED REAL BINARY 63 | ||
Expansion of the syntax representation | DES | 4, 9 |
Changes in messages to consider the new data type | MSG | 2, 4 |
Changes in V2.9B | ||
Explanation how BINILOAD handles CSV files | CRE | 2, 5 |
Changes to consider new feature | MSG | 3 |
Biniload can work with records with variable length | CRE | 5 |
Changes to consider new feature | MSG | 3 |
New BALTER statement to fill fields with specified values | CRE | 6 |
Changes to consider new feature | MSG | 3 |
Number of extents of the ALOG file are added in Database Job Variable | DBO | 9 |
Table 2: Changes in version V2.9 compared to V2.8