ALLBASE/SQL Reference Manual (36216-90216)

Appendix C 635
Sample DBEnvironment
LOADTABS Command File
LOADTABS Command File
/* This file loads each of the two tables in the ManufDB */
/* database, the six tables in the PurchDB database, */
/* and the three tables in the RecDB database with data. */
LOAD FROM EXTERNAL sampledb/SupplyBa TO ManufDB.SupplyBatches
VENDPARTNUMBER 1 16
BATCHSTAMP 18 23
MINPASSRATE 43 8 ?
END
N;
COMMIT WORK;
!echo Table SupplyBatches successfully loaded!;
LOAD FROM EXTERNAL sampledb/TestData TO ManufDB.TestData
BATCHSTAMP 1 23
TESTDATE 25 10 ?
TESTSTART 36 8 ?
TESTEND 45 8 ?
LABTIME 54 20 ?
PASSQTY 75 2 ?
TESTQTY 78 2 ?
ENDATA
N;
COMMIT WORK;
!echo Table TestData successfully loaded!;
LOAD FROM EXTERNAL sampledb/Parts TO PurchDB.Parts
PartNumber 1 16
PartName 17 30 ?
SalesPrice 47 12 ?
END
N;
COMMIT WORK;
!echo Table Parts successfully loaded!;
LOAD FROM EXTERNAL sampledb/Inventor TO PurchDB.Inventory
PartNumber 1 16
BinNumber 17 5
QtyOnHand 22 5 ?
LastCountDate 27 8 ?
CountCycle 35 5 ?
AdjustmentQty 40 5 ?
ReorderQty 45 5 ?
ReorderPoint 50 5 ?
END
N;
COMMIT WORK;
!echo Table Inventory successfully loaded!;
LOAD FROM EXTERNAL sampledb/SupplyPr TO PurchDB.SupplyPrice
PartNumber 1 16
VendorNumber 17 10
VendPartNumber 27 16
UnitPrice 43 12 ?