Beispiel

BRENAME-Lauf und neue Schema-DDL und SSL übersetzen.

Ein Reservefeld in der Satzart Kunde wird aufgeteilt in ein neues Unicode-Feld für die Kopie der Adresse und das verbleibende Reservefeld.

/START-UDS-BRENAME

***** START       BRENAME      (UDS/SQL  V2.9  0000 )     2017-06-28   11:33:10 
 
***** THE FILE: :SQL2:$XXXXXXXX.VERS.DBCOM IS COPIED TO:
      :SQL2:$XXXXXXXX.VERS.DBCOM.O
 
***** THE FILE: :SQL2:$XXXXXXXX.VERS.COSSD IS COPIED TO:
      :SQL2:$XXXXXXXX.VERS.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  0000 )     2017-06-28   11:33:11

/START-UDS-DDL

***** START         DDLCOMP     (UDS/SQL  V2.9  0000 )     2017-06-28   11:33:11
*   DDLCOMP: INPUT SYSTEMPARAMETERS

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

*  DDLCOMP: READ SCHEMA/SUBSCHEMA
%  UDS0215 UDS STARTET UDS/SQL V2.9 (LINKED-IN), DATE=2017-06-28 (ILL2038,11:33:11/0YA2)
%  UDS0746 UDS-PUBSET-DEKLARATION (CURRENT) FOLGT (ILL1746,11:33:11/0YA2) 
0YA2: UDS-PUBSET-JV:  :SQL2:$XXXXXXXX.PUBSDECL.DEFAULT
0YA2: DEFAULT PUBSET: SQL2
0YA2: ------------------------------------------
*  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 ANZAHL DER DML-ANWEISUNGEN UND I/O-ZAEHLER PRO DATENBANK  (ILL1758,11:33:11/0YA2)
 0YA2: DATABASE NAME          DMLS   LOG READ  PHYS READ  LOG WRITE PHYS WRITE
 0YA2: ------------------------------------------------------------------------
 0YA2: VERS                    658       2026         67        926         39
%  UDS0213 UDS NORMAL BEENDET MIT *************658 DML-STATEMENTS 2017-06-28 
(ILLY033,11:33:11/0YA2)
 
***** DIAGNOSTIC SUMMARY FOR DDL-SCHEMA KUNDENDATEI
 
               NO ERRORS
+++++           9 WARNINGS
 
***** END OF DIAGNOSTIC SUMMARY
***** NORMAL END   DDLCOMP      (UDS/SQL  V2.9  0000 )     2017-06-28   11:33:11

/START-UDS-SSL

***** START       SSLCOMP       (UDS/SQL  V2.9  0000 )     2017-06-28   11:33:11
*  SSLCOMP: INPUT SYSTEMPARAMETERS

SOURCE IS 'S.VERS.SSL.NEU'
END

*  SSLCOMP: READ SSL-SCHEMA
%  UDS0215 UDS STARTET UDS/SQL V2.9 (LINKED-IN), DATE=2017-06-28 (ILL2038,11:33:11/0YA2)
%  UDS0746 UDS-PUBSET-DEKLARATION (CURRENT) FOLGT (ILL1746,11:33:11/0YA2) 
0YA2: UDS-PUBSET-JV:  :SQL2:$XXXXXXXX.PUBSDECL.DEFAULT
0YA2: DEFAULT PUBSET: SQL2
0YA2: ------------------------------------------
*  SSLCOMP: START SSL-PHASE
*  SSLCOMP: CHECK SSL RULES
*  SSLCOMP: SEMANTIC TEST
*  SSLCOMP: ERROR DIAGNOSTIC
*  SSLCOMP: NO ERRORS DETECTED
%  UDS0758 ANZAHL DER DML-ANWEISUNGEN UND I/O-ZAEHLER PRO DATENBANK  (ILL1758,11:33:11/0YA2)
 0YA2: DATABASE NAME           DMLS   LOG READ  PHYS READ  LOG WRITE PHYS WRITE
 0YA2: ------------------------------------------------------------------------
 0YA2: VERS                     127        251         60         34         23
%  UDS0213 UDS NORMAL BEENDET MIT *************127 DML-STATEMENTS 2017-06-28 
(ILLY033,11:33:11/0YA2)
 
***** DIAGNOSTIC SUMMARY FOR SSL - SCHEMA
 
             NO ERRORS
             NO WARNINGS
 
***** END OF DIAGNOSTIC SUMMARY
***** NORMAL END   SSLCOMP      (UDS/SQL  V2.9  0000 )     2017-06-28   11:33:11

/START-UDS-BGSIA

***** START       BGSIA         (UDS/SQL  V2.9  0000 )     2017-06-28   11:33:11

GENERATE SCHEMA KUNDENDATEI
DISPLAY
END

%  UDS0215 UDS STARTET UDS/SQL V2.9 (LINKED-IN), DATE=2017-06-28 (ILL2038,11:33:11/0YA2) 
%  UDS0746 UDS-PUBSET-DEKLARATION (CURRENT) FOLGT (ILL1746,11:33:11/0YA2) 
0YA2: UDS-PUBSET-JV:  :SQL2:$XXXXXXXX.PUBSDECL.DEFAULT
0YA2: DEFAULT PUBSET: SQL2
0YA2: ------------------------------------------
ESTIMATE-REPORT
 
********** FOR USER-REALM     3 NAME IS : SACHRLM
     A SIZE OF          24 BLOCKS WAS ESTIMATED
 
********** FOR USER-REALM     4 NAME IS : VERSICHERTENRLM
     A SIZE OF         239 BLOCKS WAS ESTIMATED
 
********** FOR USER-REALM     6 NAME IS : TRANSPORTRLM
     A SIZE OF          24 BLOCKS WAS ESTIMATED
END OF ESTIMATE-REPORT 
%  UDS0758 ANZAHL DER DML-ANWEISUNGEN UND I/O-ZAEHLER PRO DATENBANK  (ILL1758,11:33:12/0BCV)
 0YA2: DATABASE NAME           DMLS   LOG READ  PHYS READ  LOG WRITE PHYS WRITE
 0YA2: ------------------------------------------------------------------------
 0YA2: VERS                     569        778         60        183         29
%  UDS0213 UDS NORMAL BEENDET MIT *************569 DML-STATEMENTS 2017-06-28 
(ILLY033,11:33:12/0YA2)
 
***** DIAGNOSTIC SUMMARY OF BGSIA
 
               NO WARNINGS
               NO ERRORS
               NO SYSTEM-ERRORS
 
***** END OF DIAGNOSTIC SUMMARY
***** NORMAL END   BGSIA        (UDS/SQL  V2.9  0000 )     2017-06-28   11:33:12

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

INPUT  OMF
OUTPUT LIBRARY= :SQL2:$XXXXXXXX.VERS.HASHLIB
        ADD UDSHASH AS (R)UDSHASH/@(0003)/2017-06-28 , OUTPUT REPLACED

//SHOW-ELEM-ATTR



INPUT  LIBRARY= :SQL2:$XXXXXXXX.VERS.HASHLIB
TYP NAME    VER (VAR#) DATE        NAME    VER (VAR#) DATE
(R) ADMIN## @   (0001) 2017-06-28   UDSHASH @   (0003) 2017-06-28
      2 (R)-ELEMENT(S) IN THIS TABLE OF CONTENTS

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

Prüfung der Umbenennung mit BALTER

/START-UDS-BALTER

***** START       BALTER        (UDS/SQL  V2.9  0000 )     2017-06-28   11:33:12

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  0000 )     2017-06-28   11:33:12

Listausgabe von BALTER

 RENAME CHECK    FOR SCHEMA                     KUNDENDATEI
 RENAME CHECK    SIA_CONTROL
 RENAME CHECK    AREA
 NO CHANGES IN   ALL                          4 AREA(S)
 RENAME CHECK    RECORD
 |--------------------------------------------------------------------------------------------|
 | DIFFERENCE IN         RECORD              KUNDE                                            |
 |--------------------------------------------------------------------------------------------|
 |                                                                                            |
 |   +++ 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

Übersetzung des Subschemas

/START-UDS-DDL

***** START       DDLCOMP     (UDS/SQL  V2.9  0000 )     2017-06-28   11:33:12
*  DDLCOMP: INPUT SYSTEMPARAMETERS

SOURCE IS 'S.VERS.SUBDDL.NEU'
END

*  DDLCOMP: READ SCHEMA/SUBSCHEMA
%  UDS0215 UDS STARTET UDS/SQL V2.9 (LINKED-IN), DATE=2017-06-28 (ILL2038,11:33:12/0YA2) 
%  UDS0746 UDS-PUBSET-DEKLARATION (CURRENT) FOLGT (ILL1746,11:33:12/0YA2) 
0YA2: UDS-PUBSET-JV:  :SQL2:$XXXXXXXX.PUBSDECL.DEFAULT
0YA2: DEFAULT PUBSET: SQL2
0YA2: ------------------------------------------
*  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 ANZAHL DER DML-ANWEISUNGEN UND I/O-ZAEHLER PRO DATENBANK  (ILL1758,11:33:12/0YA2) 
 0YA2: DATABASE NAME          DMLS   LOG READ  PHYS READ  LOG WRITE PHYS WRITE
 0YA2: ------------------------------------------------------------------------
 0YA2: VERS                  1379      2613        75       639        47
%  UDS0213 UDS NORMAL BEENDET MIT ************1379 DML-STATEMENTS 2017-06-28 
(ILLY033,11:33:12/0YA2)
 
***** DIAGNOSTIC SUMMARY FOR DDL-SUBSCHEMA
 
               NO ERRORS
               NO WARNINGS
 
***** END OF DIAGNOSTIC SUMMARY
***** NORMAL END   DDLCOMP      (UDS/SQL  V2.9  0000 )     2017-06-28   11:33:12

/START-UDS-BGSSIA

***** START       BGSSIA        (UDS/SQL  V2.9  0000 )     2017-06-28   11:33:12

GENERATE SUBSCHEMA VERWALTUNG OF SCHEMA KUNDENDATEI
DISPLAY
END 

%  UDS0215 UDS STARTET UDS/SQL V2.9 (LINKED-IN), DATE=2017-06-28 (ILL2038,11:33:12/0YA2) 
%  UDS0746 UDS-PUBSET-DEKLARATION (CURRENT) FOLGT (ILL1746,11:33:12/0YA2) 
0YA2: UDS-PUBSET-JV:  :SQL2:$XXXXXXXX.PUBSDECL.DEFAULT
0YA2: DEFAULT PUBSET: SQL2
0YA2: ------------------------------------------
*** SSIA GENERATION NORMALLY ENDED.
*GENERATION OF ITEM-TABLE AND NAME-TABLE STARTED.
*GENERATION OF ITEM-TABLE AND NAME-TABLE FINISHED.
%  UDS0758 ANZAHL DER DML-ANWEISUNGEN UND I/O-ZAEHLER PRO DATENBANK  (ILL1758,11:33:12/0YA2)
 0YA2: DATABASE NAME           DMLS   LOG READ  PHYS READ  LOG WRITE PHYS WRITE
 0YA2: ------------------------------------------------------------------------
 0YA2: VERS                     802       1392         76        297         29
%  UDS0213 UDS NORMAL BEENDET MIT *************802 DML-STATEMENTS 2017-06-28 
(ILLY033,11:33:12/0YA2)
 
***** DIAGNOSTIC SUMMARY OF BGSSIA
 
               NO WARNINGS
               NO ERRORS
               NO SYSTEM-ERRORS
 
***** END OF DIAGNOSTIC SUMMARY
***** NORMAL END   BGSSIA       (UDS/SQL  V2.9  0000 )     2017-06-28   11:33:12

Die Umbenennung der Datenbankobjekte ist hiermit fertig.