Loading...
Select Version
Example of BOUTLOAD
Record type COLORS from database SHIPPING is copied.
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL, VERSION=02.9B00
/START-UDS-BOUTLOAD
***** START BOUTLOAD (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:53
//OPEN-DATABASE DATABASE-NAME=SHIPPING
//COPY-RECORD RECORD-NAME=COLORS,REALM-NAME=ARTICLE-RLM
3903 AFTER " REALM-NAME = <NAME> " ONLY THE " END " STATEMENT IS ALLOWED
//END
***** INPUT CHECK SUCCESSFULLY TERMINATED
***** BEGIN SCAN OF USER-REALMS
***** REALM: ARTICLE-RLM
***** 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 1801 ) 2019-01-29 09:27:53
Example of BOUTLOAD and BINILOAD
The record type MATERIALS is copied and deleted with BOUTLOAD and stored with BINILOAD. BINILOAD uses the output generated by BOUTLOAD for the input of data and BINILOAD statements.
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL, VERSION=02.9B00
/START-UDS-BOUTLOAD
***** START BOUTLOAD (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:53
//OPEN-DATABASE DATABASE-NAME=SHIPPING
//COPY-RECORD RECORD-NAME=MATERIALS,REALM-NAME=ARTICLE-RLM
3903 AFTER " REALM-NAME = <NAME> " ONLY THE " END " STATEMENT IS ALLOWED
//END
***** INPUT CHECK SUCCESSFULLY TERMINATED
***** BEGIN SCAN OF USER-REALMS
***** REALM: ARTICLE-RLM
***** SCAN OF USER-REALMS SUCCESSFULLY TERMINATED
BINILOAD PARAMETERS FOR RECORD : MATERIALS , REC-REF : 12 - (1)
SCHEMA NAME IS MAIL-ORDERS - (1)
SUBSCHEMA NAME IS - (1)
USER FILE RECORD LENGTH IS 29 - (1)
USER FILE BUFFER LENGTH IS 8192 - (1)
INPUT FILE 'SHIPPING.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 v
RECORD-AREA NAME IS ARTICLE-RLM - (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 1801 ) 2019-01-29 09:27:53
.
.
.
(1) - BINILOAD statements that are generated by BOUTLOAD and used as input for BINILOAD.
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL, VERSION=02.9B00
/START-UDS-BOUTLOAD
***** START BOUTLOAD (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:54
//OPEN-DATABASE DATABASE-NAME=SHIPPING
//REMOVE-RECORD RECORD-NAME=MATERIALS
//END
***** INPUT CHECK SUCCESSFULLY TERMINATED
***** NO OCCURRENCES OF MEMBER RECORDS DETECTED
***** BEGIN SCAN OF USER-REALMS
***** REALM: ARTICLE-RLM
***** 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 : 100
***** NORMAL END BOUTLOAD (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:54
.
.
.
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL, VERSION=02.9B00
/START-UDS-BINILOAD
***** START BINILOAD (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:55
EXECUTION WITH CHECK. - (1)
SCHEMA NAME IS MAIL-ORDERS - (1)
SUBSCHEMA NAME IS ADMIN - (1)
USER FILE RECORD LENGTH IS 29 - (1)
USER FILE BUFFER LENGTH IS 8192 - (1)
INPUT FILE 'SHIPPING.REC00012.00011' - (1)
INPUT RECORDNUMBER IS 10 - (1)
STORE RECORD NAME IS MATERIALS - (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 ARTICLE-RLM - (1)
END - (1)
BEGIN CHECK-RUN
*** DATE AND TIME 2019-01-29 09:27:55
BEGIN ALLOCATION
*** DATE AND TIME 2019-01-29 09:27:55
SEARCHKEY ON RECORD-LEVEL:
--------------------------
REC REF: 12
RECORD NAME: MATERIALS
SEARCHKEY TABLE, DBTT_COLUMN_NR: 1
*** ICRELES: MOVE_ROUTINE SORTKF CREATED
BEGIN TABLE-PROCESSOR
*** DATE AND TIME 2019-01-29 09:27:56
SEARCHKEY ON RECORD-LEVEL:
--------------------------
REC REF: 12
RECORD NAME: MATERIALS
SEARCHKEY TABLE, DBTT_COLUMN_NR: 2
*** NO ERRORS DETECTED DURING CHECK-RUN
END CHECK-RUN
*** DATE AND TIME 2019-01-29 09:27:56
BEGIN ALLOCATION
*** DATE AND TIME 2019-01-29 09:27:56
*** DATABASE IS IN USE
SEARCHKEY ON RECORD-LEVEL:
--------------------------
REC REF: 12
RECORD NAME: MATERIALS
SEARCHKEY TABLE, DBTT_COLUMN_NR: 1
*** ICRELES: MOVE_ROUTINE SORTKF CREATED
BEGIN TABLE-PROCESSOR
*** DATE AND TIME 2019-01-29 09:27:56
SEARCHKEY ON RECORD-LEVEL:
--------------------------
REC REF: 12
RECORD NAME: MATERIALS
SEARCHKEY TABLE, DBTT_COLUMN_NR: 2
BEGIN STORE DB-RECORD
*** DATE AND TIME 2019-01-29 09:27:56
STORING DATABASE RECORDS
END STORE DB-RECORD
*** DATE AND TIME 2019-01-29 09:27:56
END CLOSE
*** DATE AND TIME 2019-01-29 09:27:56
***** DIAGNOSTIC SUMMARY OF BINILOAD
NO WARNINGS
NO ERRORS
NO SYSTEM-ERRORS
10 RECORDS STORED
***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES : 108
***** NORMAL END BINILOAD (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:56
(1) - BINILOAD statements that are generated by BOUTLOAD and used as input for BINILOAD.