Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

Beispiele

Beispiel zu BOUTLOAD

Es wird die Satzart FARBEN aus der Datenbank VERSAND kopiert.

/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL,    VERSION=02.9B00 
/START-UDS-BOUTLOAD
***** START       BOUTLOAD     (UDS/SQL  V2.9  0000 )     2017-06-28   11:26:37
//OPEN-DATABASE DATABASE-NAME=VERSAND
//COPY-RECORD RECORD-NAME=FARBEN,REALM-NAME=ARTIKELRLM
3903  AFTER " REALM-NAME = <NAME> " ONLY THE " END " STATEMENT IS ALLOWED
//END
***** INPUT CHECK SUCCESSFULLY TERMINATED
***** BEGIN SCAN OF USER-REALMS
***** REALM: ARTIKELRLM
***** SCAN OF USER-REALMS SUCCESSFULLY TERMINATED
 
***** DIAGNOSTIC SUMMARY OF BOUTLOAD
 
             NO WARNINGS
             NO ERRORS
             NO SYSTEM-ERRORS
 
***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES  :          32
***** NORMAL END   BOUTLOAD     (UDS/SQL  V2.9  0000 )     2017-06-28   11:26:37


Beispiel zu BOUTLOAD und BINILOAD

Kopieren und Löschen der Satzart MATERIALIEN mit BOUTLOAD und Speichern derselben Satzart mit BINILOAD. Dabei verwendet BINILOAD die von BOUTLOAD erzeugten Ausgaben für die Eingabe der Daten und für die Eingabe der BINILOAD-Anweisungen.


/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL,    VERSION=02.9B00 
/START-UDS-BOUTLOAD
***** START       BOUTLOAD     (UDS/SQL  V2.9  0000 )     2017-06-28   11:26:37
//OPEN-DATABASE DATABASE-NAME=VERSAND
//COPY-RECORD RECORD-NAME=MATERIALIEN,REALM-NAME=ARTIKELRLM
3903  AFTER " REALM-NAME = <NAME> " ONLY THE " END " STATEMENT IS ALLOWED
//END
***** INPUT CHECK SUCCESSFULLY TERMINATED
***** BEGIN SCAN OF USER-REALMS
***** REALM: ARTIKELRLM
***** SCAN OF USER-REALMS SUCCESSFULLY TERMINATED
 
BINILOAD PARAMETERS FOR RECORD : MATERIALIEN                  , REC-REF :   12
SCHEMA NAME IS ARTIKELVERSAND                                                  - (1)
SUBSCHEMA NAME IS                                                              - (1)
USER FILE RECORD LENGTH IS   29                                                - (1)
USER FILE BUFFER LENGTH IS 8192                                                - (1)
INPUT FILE 'VERSAND.REC00012.00011'                                            - (1)
INPUT RECORDNUMBER IS      10                                                  - (1)
STORE RECORD NAME IS MATERIALIEN                                               - (1)
RECORD-DBKEY IS DISPL IS 0 , LENGTH IS 8                                       - (1)
RECORD-DISPL IS 0 , DISPL IS    8 , LENGTH IS   21                             - (1)
RECORD-AREA NAME IS ARTIKELRLM                                                 - (1)
END                                                                            - (1)
                                                                             
 ***** DIAGNOSTIC SUMMARY OF BOUTLOAD

              NO WARNINGS
              NO ERRORS
              NO SYSTEM-ERRORS
 
 ***** END OF DIAGNOSTIC SUMMARY
 ***** NR OF DATABASE ACCESSES  :          32
 ***** NORMAL END   BOUTLOAD     (UDS/SQL  V2.9  0000 )     2017-06-28   11:26:37
.
.
.

(1)  von BOUTLOAD erzeugte BINILOAD-Anweisungen, die als Eingabe für BINILOAD verwendet werden.

 /SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL,    VERSION=02.9B00 
 /START-UDS-BOUTLOAD
 ***** START       BOUTLOAD     (UDS/SQL  V2.9  0000 )     2017-06-28   11:26:37
 //OPEN-DATABASE DATABASE-NAME=VERSAND
 //REMOVE-RECORD RECORD-NAME=MATERIALIEN
 //END
 ***** INPUT CHECK SUCCESSFULLY TERMINATED
 ***** NO OCCURRENCES OF MEMBER RECORDS DETECTED
 ***** BEGIN SCAN OF USER-REALMS
 ***** REALM: ARTIKELRLM
 ***** SCAN OF USER-REALMS SUCCESSFULLY TERMINATED
 
 ***** DIAGNOSTIC SUMMARY OF BOUTLOAD

              NO WARNINGS
              NO ERRORS
              NO SYSTEM-ERRORS

 ***** END OF DIAGNOSTIC SUMMARY
 ***** NR OF DATABASE ACCESSES  :          92
 ***** NORMAL END   BOUTLOAD     (UDS/SQL  V2.9  0000 )     2017-06-28   11:26:38
.
.
.
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL,    VERSION=02.9B00 
/START-UDS-BINILOAD
***** START       BINILOAD     (UDS/SQL  V2.9  0000 )     2017-06-28   11:26:39 
EXECUTION WITH CHECK.                                                           - (1)
SCHEMA NAME IS ARTIKELVERSAND                                                   - (1)
SUBSCHEMA NAME IS ADMIN                                                         - (1)
USER FILE RECORD LENGTH IS   29                                                 - (1)
USER FILE BUFFER LENGTH IS 8192
INPUT FILE 'VERSAND.REC00012.00011'                                             - (1)
INPUT RECORDNUMBER IS      10                                                   - (1)
STORE RECORD NAME IS MATERIALIEN                                                - (1)
RECORD-DBKEY IS DISPL IS 0 , LENGTH IS 8                                        - (1)
RECORD-DISPL IS 0 , DISPL IS    8 , LENGTH IS   21                              - (1)
RECORD-AREA NAME IS ARTIKELRLM                                                  - (1)
END                                                                             - (1)
BEGIN CHECK-RUN
*** DATE AND TIME 2017-06-28  11:26:39
BEGIN ALLOCATION
*** DATE AND TIME 2017-06-28  11:26:39
SEARCHKEY ON RECORD-LEVEL:
--------------------------
REC REF:    12
RECORD NAME: MATERIALIEN
SEARCHKEY TABLE, DBTT_COLUMN_NR:     1
*** ICRELES: MOVE_ROUTINE SORTKF CREATED
BEGIN TABLE-PROCESSOR
*** DATE AND TIME 2017-06-28  11:26:40
SEARCHKEY ON RECORD-LEVEL:
--------------------------
REC REF:    12
RECORD NAME: MATERIALIEN
SEARCHKEY TABLE, DBTT_COLUMN_NR:     2
*** NO ERRORS DETECTED DURING CHECK-RUN
END CHECK-RUN
*** DATE AND TIME 2017-06-28  11:26:40
BEGIN ALLOCATION
*** DATE AND TIME 2017-06-28  11:26:40
*** DATABASE IS IN USE
SEARCHKEY ON RECORD-LEVEL:
--------------------------
REC REF:    12
RECORD NAME: MATERIALIEN
SEARCHKEY TABLE, DBTT_COLUMN_NR:     1
*** ICRELES: MOVE_ROUTINE SORTKF CREATED
BEGIN TABLE-PROCESSOR
*** DATE AND TIME 2017-06-28  11:26:40
SEARCHKEY ON RECORD-LEVEL:
--------------------------
REC REF:    12
RECORD NAME: MATERIALIEN
SEARCHKEY TABLE, DBTT_COLUMN_NR:     2
BEGIN STORE DB-RECORD
*** DATE AND TIME 2017-06-28  11:26:40
STORING DATABASE RECORDS
END STORE DB-RECORD
*** DATE AND TIME 2017-06-28  11:26:40
END CLOSE
*** DATE AND TIME 2017-06-28  11:26:40
 
***** DIAGNOSTIC SUMMARY OF BINILOAD
 
             NO WARNINGS
             NO ERRORS
             NO SYSTEM-ERRORS
 
             10 RECORDS  STORED
 
***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES  :           96
***** NORMAL END   BINILOAD     (UDS/SQL  V2.9  0000 )     2017-06-28   11:26:40

(1)  von BOUTLOAD erzeugte BINILOAD-Anweisungen, die als Eingabe für BINILOAD verwendet werde