Loading...
Select Version
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