Example

BRENAME run and compiling new Schema DDL and SSL

A reserve item in the record type Customer is split into a new Unicode item for the copy of the address and the remaining reserve item.

/START-UDS-BRENAME

***** START        BRENAME      (UDS/SQL V2.9  1801 )     2019-01-29   09:35:50


***** THE FILE: :IUDS:$XXXXXXXX.INSURE.DBCOM IS COPIED TO:
      :IUDS:$XXXXXXXX.INSURE.DBCOM.O


***** THE FILE: :IUDS:$XXXXXXXX.INSURE.COSSD IS COPIED TO:
      :IUDS:$XXXXXXXX.INSURE.COSSD.O
1005 RENAMING SUCCESSFULLY INITIATED

***** DIAGNOSTIC SUMMARY OF BRENAME

               NO WARNINGS
               NO ERRORS
               NO SYSTEM-ERRORS

***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES  :          90
***** NORMAL END   BRENAME      (UDS/SQL V2.9  1801 )     2019-01-29   09:35:51

/START-UDS-DDL

***** START        DDLCOMP      (UDS/SQL V2.9  1801 )     2019-01-29   09:35:51 
*  DDLCOMP: INPUT SYSTEMPARAMETERS 

SOURCE IS 'S.INSURE.DDL.RENAME'
END

*  DDLCOMP: READ SCHEMA/SUBSCHEMA 
%  UDS0215 UDS STARTING UDS/SQL V2.9 (LINKED-IN), DATE=2019-01-29 (ILL2038,09:35:51/4TE7)
%  UDS0746 UDS PUBSET DECLARATION (CURRENT) FOLLOWS (ILL1746,09:35:51/4TE7)
4TE7: UDS-PUBSET-JV:  :IUDS:$XXXXXXXX.PUBSDECL.DEFAULT
4TE7: DEFAULT PUBSET: IUDS
4TE7: ------------------------------------------
*  DDLCOMP: START SCHEMA-PHASE
*  DDLCOMP: CHECK SCHEMA RULES
*  DDLCOMP: CHECK DATA ALLOCATION
*  DDLCOMP: SEMANTIC TEST
*  DDLCOMP: CYCLUS TESTS
*  DDLCOMP: ERROR DIAGNOSTIC
*  DDLCOMP: NO ERRORS IN SCHEMA-PHASE
*  DDLCOMP: CREATE FILE COSSD
*  DDLCOMP: NO ERRORS DETECTED
%  UDS0758 NUMBER OF DML-STATEMENTS AND I/O COUNTERS PER DATABASE  (ILL1758,09:35:51/4TE7) 
4TE7: DATABASE NAME            DMLS   LOG READ  PHYS READ  LOG WRITE PHYS WRITE
4TE7: -------------------------------------------------------------------------
4TE7: INSURE                    658       2026         67        926         39
%  UDS0213 UDS NORMAL SYSTEM TERMINATION WITH *************658 DML-STATEMENTS 2019-01-29
(ILLY033,09:35:51/4TE7)

***** DIAGNOSTIC SUMMARY FOR DDL-SCHEMA CUSTOMER-CARDS

               NO ERRORS
+++++           9 WARNINGS

***** END OF DIAGNOSTIC SUMMARY
***** NORMAL END   DDLCOMP      (UDS/SQL V2.9  1801 )     2019-01-29   09:35:51 

/START-UDS-SSL

***** START        SSLCOMP      (UDS/SQL V2.9  1801 )     2019-01-29   09:35:52
*  SSLCOMP: INPUT SYSTEMPARAMETERS

SOURCE IS 'S.INSURE.SSL.NEW'
END

*  SSLCOMP: READ SSL-SCHEMA
%  UDS0215 UDS STARTING UDS/SQL V2.9 (LINKED-IN), DATE=2019-01-29 (ILL2038,09:35:52/4TE7)
%  UDS0746 UDS PUBSET DECLARATION (CURRENT) FOLLOWS (ILL1746,09:35:52/4TE7) 
4TE7: UDS-PUBSET-JV:  :IUDS:$XXXXXXXX.PUBSDECL.DEFAULT
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:35:52/4TE7) 
4TE7: DATABASE NAME           DMLS   LOG READ  PHYS READ  LOG WRITE PHYS WRITE
4TE7: ------------------------------------------------------------------------
4TE7: INSURE                   127        251         60         34         23
%  UDS0213 UDS NORMAL SYSTEM TERMINATION WITH *************127 DML-STATEMENTS 2019-01-29
(ILLY033,09:35:52/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:35:52

/START-UDS-BGSIA

***** START        BGSIA        (UDS/SQL V2.9  1801 )    2019-01-29   09:35:52

GENERATE SCHEMA CUSTOMER-CARDS
DISPLAY
END

%  UDS0215 UDS STARTING UDS/SQL V2.9 (LINKED-IN), DATE=2019-01-29 (ILL2038,09:35:52/4TE7) 
%  UDS0746 UDS PUBSET DECLARATION (CURRENT) FOLLOWS (ILL1746,09:35:52/4TE7) 
4TE7: UDS-PUBSET-JV:  :IUDS:$XXXXXXXX.PUBSDECL.DEFAULT
4TE7: DEFAULT PUBSET: IUDS
4TE7: ------------------------------------------
ESTIMATE-REPORT
 
********** FOR USER-REALM     3 NAME IS : PROP-RLM
      A SIZE OF         24 BLOCKS WAS ESTIMATED
 
********** FOR USER-REALM     4 NAME IS : INSURE-RLM
      A SIZE OF        239 BLOCKS WAS ESTIMATED
 
********** FOR USER-REALM     6 NAME IS : TRANSPORT-RLM
      A SIZE OF         24 BLOCKS WAS ESTIMATED
END OF ESTIMATE-REPORT
%  UDS0758 NUMBER OF DML-STATEMENTS AND I/O COUNTERS PER DATABASE (ILL1758,09:35:52/4TE7) 
4TE7: DATABASE NAME            DMLS   LOG READ  PHYS READ  LOG WRITE PHYS WRITE
4TE7: -------------------------------------------------------------------------
4TE7: INSURE                    569        778         60        183         29
%  UDS0213 UDS NORMAL SYSTEM TERMINATION WITH *************569 DML-STATEMENTS 2019-01-29
(ILLY033,09:35:53/4TE7)
 
***** DIAGNOSTIC SUMMARY OF BGSIA
 
               NO WARNINGS
               NO ERRORS
               NO SYSTEM-ERRORS
 
***** END OF DIAGNOSTIC SUMMARY
***** NORMAL END   BGSIA        (UDS/SQL V2.9  1801 )     2019-01-29   09:35:53

/MODIFY-JOB-SWITCHES ON=(1,4)
/START-LMS
//MODIFY-LOGGING-PARAMETERS LOG=*MAX
//OPEN-LIBRARY LIB=INSURE.HASHLIB,MODE=*UPDATE
//ADD-ELEMENT FROM-FILE=*OMF,TO-ELEM=*LIB-ELEM(TYPE=R),WRITE-MODE=*ANY

INPUT OMF
OUTPUT LIBRARY= :IUDS:$XXXXXXXX.INSURE.HASHLIB
         ADD UDSHASH AS (R)UDSHASH/@(0003)/2019-01-29 , OUTPUT REPLACED

//SHOW-ELEM-ATTR

INPUT LIBRARY= :IUDS:$XXXXXXXX.INSURE.HASHLIB
TYP NAME    VER (VAR#) DATE          NAME    VER (VAR#) DATE
(R) ADMIN## @   (0001) 2019-01-29    UDSHASH @   (0003) 2019-01-29
       2 (R)-ELEMENT(S) IN THIS TABLE OF CONTENTS 

//END
/MODIFY-JOB-SWITCHES OFF=(1) 

Checking the renaming using BALTER

/START-UDS-BALTER

***** START        BALTER       (UDS/SQL V2.9  1801 )     2019-01-29   09:35:53 

REPORT    IS YES .
END.


+++++ WARNING: 1091     1 CHANGE(S) OF ITEM TYPE
+++++ WARNING: 1096     1 CHANGE(S) WITH SPLIT OF ITEMS

NUMBER OF FILE ACCESSES:            0
 
 
***** DIAGNOSTIC SUMMARY OF BALTER
 
+++++           2 WARNINGS
               NO ERRORS
               NO SYSTEM-ERRORS
 
***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES  :         119
***** NORMAL END   BALTER       (UDS/SQL V2.9  1801 )     2019-01-29   09:35:53

List output of BALTER:

RENAME CHECK    FOR SCHEMA                     CUSTOMER-CARDS  
RENAME CHECK    SIA_CONTROL                                    
RENAME CHECK    AREA                                           
NO CHANGES IN   ALL                          4 AREA(S)         
RENAME CHECK    RECORD                                         
|--------------------------------------------------------------------------------------------|
| DIFFERENCE IN         RECORD              CUSTOMER                                         |
|--------------------------------------------------------------------------------------------|
|                                                                                            |
|   +++ WARNING +++     DIFFERENCE IN       ITEM_TYPE           NOT-USED                     |
|                                                                                            |
|   ITEM SPLIT                                                                               |
|       ITEM-NAME (OLD SIA)            LENGTH TYPE    |   ITEM-NAME (NEW SIA)   LENGTH TYPE  |
|       NOT-USED                          255 CHAR    |   ADRESSE-U               240 NCHAR  |
|                                                     |   NOT-USED                 15 CHAR   |
|--------------------------------------------------------------------------------------------|
NO CHANGES IN   REMAINING                    3 RECORD(S)                             
RENAME CHECK    SET                                                                  
NO CHANGES IN   ALL                         13 SET(S)                                
RENAME CHECK    KEYS IN SIA                                                          
NO CHANGES IN   ALL                          5 KEY(S)                                


+++++ WARNING: 1091     1 CHANGE(S) OF ITEM TYPE                                     


+++++ WARNING: 1096     1 CHANGE(S) WITH SPLIT OF ITEMS                              


NUMBER OF FILE ACCESSES:            0                                                


***** DIAGNOSTIC SUMMARY OF BALTER                                                    


+++++         2 WARNINGS                                                    
             NO ERRORS                                                       
             NO SYSTEM-ERRORS                                                


***** END OF DIAGNOSTIC SUMMARY                                               


***** NR OF DATABASE ACCESSES  :          119 

Compiling the subschema
/START-UDS-DDL

***** START       DDLCOMP      (UDS/SQL (UDS/SQL  V2.9  1801 )     2019-01-29   09:35:53
*  DDLCOMP: INPUT SYSTEMPARAMETERS 

SOURCE IS 'S.INSURE.SUBDDL.NEW'
END

*  DDLCOMP: READ SCHEMA/SUBSCHEMA
%  UDS0215 UDS STARTING UDS/SQL V2.9 (LINKED-IN), DATE=2019-01-29 (ILL2038,09:35:53/4TE7)  
%  UDS0746 UDS PUBSET DECLARATION (CURRENT) FOLLOWS (ILL1746,09:35:53/4TE7) 
4TE7: UDS-PUBSET-JV:  :IUDS:$XXXXXXXX.PUBSDECL.DEFAULT
4TE7: DEFAULT PUBSET: IUDS
4TE7: ------------------------------------------
*  DDLCOMP: START SUBSCHEMA-PHASE
*  DDLCOMP: CHECK SUBSCHEMA RULES
*  DDLCOMP: CHECK DATA ALLOCATION
*  DDLCOMP: SUBCOPY
*  DDLCOMP: ERROR DIAGNOSTIC
*  DDLCOMP: NO ERRORS IN SUBSCHEMA-PHASE
*  DDLCOMP: WRITE SUBSCHEMA ON COSSD
*  DDLCOMP: NO ERRORS DETECTED
%  UDS0758 NUMBER OF DML-STATEMENTS AND I/O COUNTERS PER DATABASE  (ILL2038,09:35:53/4TE7)
4TE7: DATABASE NAME            DMLS   LOG READ  PHYS READ  LOG WRITE PHYS WRITE
4TE7: -------------------------------------------------------------------------
4TE7: INSURE                   1379       2613         75        639         47
%  UDS0213 UDS NORMAL SYSTEM TERMINATION WITH ************1379 DML-STATEMENTS 2019-01-29
(ILLY033,09:35:54/4TE7)

***** DIAGNOSTIC SUMMARY FOR DDL-SUBSCHEMA

               NO ERRORS
               NO WARNINGS

***** END OF DIAGNOSTIC SUMMARY
***** NORMAL END   DDLCOMP      (UDS/SQL V2.9  1801 )     2019-01-29   09:35:54

/START-UDS-BGSSIA

***** START        BGSSIA       (UDS/SQL V2.9  1801 )     2019-01-29   09:35:54

GENERATE SUBSCHEMA MANAGEMENT OF SCHEMA CUSTOMER-CARDS
DISPLAY
END

%  UDS0215 UDS STARTING UDS/SQL V2.9 (LINKED-IN), DATE=2019-01-29 (ILL2038,09:35:54/4TE7)
%  UDS0746 UDS PUBSET DECLARATION (CURRENT) FOLLOWS (ILL1746,09:35:54/4TE7) 
4TE7: UDS-PUBSET-JV:  :IUDS:$XXXXXXXX.PUBSDECL.DEFAULT
4TE7: DEFAULT PUBSET: IUDS
4TE7: ------------------------------------------
*** SSIA GENERATION NORMALLY ENDED.
*GENERATION OF ITEM-TABLE AND NAME-TABLE STARTED.
*GENERATION OF ITEM-TABLE AND NAME-TABLE FINISHED.
%  UDS0758 NUMBER OF DML-STATEMENTS AND I/O COUNTERS PER DATABASE (ILL1758,09:35:54/4TE7) 
4TE7: DATABASE NAME            DMLS   LOG READ  PHYS READ  LOG WRITE PHYS WRITE
4TE7: -------------------------------------------------------------------------
4TE7: INSURE                    802       1392         76        297         29
%  UDS0213 UDS NORMAL SYSTEM TERMINATION WITH *************802 DML-STATEMENTS 2019-01-29
(ILLY033,09:35:54/4TE7)
***** DIAGNOSTIC SUMMARY OF BGSSIA

               NO WARNINGS
               NO ERRORS
               NO SYSTEM-ERRORS

***** END OF DIAGNOSTIC SUMMARY
***** NORMAL END   BGSSIA      (UDS/SQL V2.9  1801 )     2019-01-29   09:35:54

Renaming of the database objects has now been completed.