Beispiel zu BINILOAD

Die Satzart ARTIKEL wird in die Datenbank VERSAND gespeichert. Als Eingabedatei wird die von BOUTLOAD erzeugte Datei VERSAND.REC00009.00005 verwendet.

/ADD-FILE-LINK LINK-NAME=DATABASE,FILE-NAME=VERSAND.DBDIR
/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:38
EXECUTION WITH CHECK.
SCHEMA NAME IS ARTIKELVERSAND
SUBSCHEMA NAME IS ADMIN
USER FILE RECORD LENGTH IS  112
USER FILE BUFFER LENGTH IS 8192
INPUT FILE 'VERSAND.REC00009.00005                            '
INPUT RECORDNUMBER IS      55
STORE RECORD NAME IS ARTIKEL
RECORD-DBKEY IS DISPL IS 0 , LENGTH IS 8
RECORD-DISPL IS 0 , DISPL IS   25 , LENGTH IS   87
RECORD-AREA NAME IS KLEIDUNG
INSERT INTO SET NAME IS BESTELLANGABEN
OWNER DBKEY IS DISPL IS    8 , LENGTH IS 8
INSERT INTO SET NAME IS MIN-BESTAND-ERREICHT
OWNER KEY IS DISPL IS   16 , LENGTH IS 1
INSERT INTO SET NAME IS LIEFERBARE-ARTIKEL
OWNER DBKEY IS DISPL IS   17 , LENGTH IS 8
END
BEGIN CHECK-RUN
*** DATE AND TIME 2017-06-28  11:26:38
BEGIN ALLOCATION
*** DATE AND TIME 2017-06-28  11:26:38
 
SET_NAME: BESTELLANGABEN
SET_REF:     7
SORTKEY TABLE, DBTT_COLUMN_NR:     1
*** ICRELES: MOVE_ROUTINE SORTKF CREATED
CALCKEY TABLE - INDIRECT
*** DATE AND TIME 2017-06-28  11:26:38
BEGIN TABLE-PROCESSOR
*** DATE AND TIME 2017-06-28  11:26:38
 
SET_NAME: MIN-BESTAND-ERREICHT
SET_REF:     8
SORTKEY TABLE, DBTT_COLUMN_NR:     1
BEGIN TABLE-PROCESSOR
*** DATE AND TIME 2017-06-28  11:26:38
 
SET_NAME: LIEFERBARE-ARTIKEL
SET_REF:    12
SORTKEY TABLE, DBTT_COLUMN_NR:     1
BEGIN TABLE-PROCESSOR
*** DATE AND TIME 2017-06-28  11:26:38
SEARCHKEY TABLE, DBTT_COLUMN_NR:     2
INDIRECT CALC-SEARCH-KEY BUCKETS
INDIRECT CALC-SEARCH-KEY BUCKETS
*** NO ERRORS DETECTED DURING CHECK-RUN
END CHECK-RUN
*** DATE AND TIME 2017-06-28  11:26:38
BEGIN ALLOCATION
*** DATE AND TIME 2017-06-28  11:26:38
*** DATABASE IS IN USE
 
SET_NAME: BESTELLANGABEN
SET_REF:     7
SORTKEY TABLE, DBTT_COLUMN_NR:     1
*** ICRELES: MOVE_ROUTINE SORTKF CREATED
CALCKEY TABLE - INDIRECT 
*** DATE AND TIME 2017-06-28  11:26:39
BEGIN TABLE-PROCESSOR
*** DATE AND TIME 2017-06-28  11:26:39
 
SET_NAME: MIN-BESTAND-ERREICHT
SET_REF:     8
SORTKEY TABLE, DBTT_COLUMN_NR:     1
BEGIN TABLE-PROCESSOR
*** DATE AND TIME 2017-06-28  11:26:39
 
SET_NAME: LIEFERBARE-ARTIKEL
SET_REF:    12
SORTKEY TABLE, DBTT_COLUMN_NR:     1
BEGIN TABLE-PROCESSOR
*** DATE AND TIME 2017-06-28  11:26:39
SEARCHKEY TABLE, DBTT_COLUMN_NR:     2
INDIRECT CALC-SEARCH-KEY BUCKETS
INDIRECT CALC-SEARCH-KEY BUCKETS
BEGIN STORE DB-RECORD
*** DATE AND TIME 2017-06-28  11:26:39
STORING DATABASE RECORDS
END STORE DB-RECORD
 
*** DATE AND TIME 2017-06-28  11:26:39
END CLOSE
*** DATE AND TIME 2017-06-28  11:26:39
 
***** DIAGNOSTIC SUMMARY OF BINILOAD
 
             NO WARNINGS
             NO ERRORS
             NO SYSTEM-ERRORS
 
             55 RECORDS  STORED
 
***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES  :          184
***** NORMAL END   BINILOAD     (UDS/SQL  V2.9  0000 )     2017-06-28   11:26:39

BINILOAD Eingabedatei

Beispiel zum Zusammenwirken von BINILOAD und BOUTLOAD siehe "Beispiele".