ALLBASE/SQL Reference Manual (36216-90216)

636 AppendixC
Sample DBEnvironment
LOADTABS Command File
DeliveryDays 55 5 ?
DiscountQty 60 5 ?
END
N;
COMMIT WORK;
!echo Table SupplyPrice successfully loaded!;
LOAD FROM EXTERNAL sampledb/Orders TO PurchDB.Orders
OrderNumber 1 10
VendorNumber 11 10 ?
OrderDate 21 8 ?
END
N;
COMMIT WORK;
!echo Table Orders successfully loaded!;
LOAD FROM EXTERNAL sampledb/OrderIte TO PurchDB.OrderItems
OrderNumber 1 10
ItemNumber 11 10
VendPartNumber 21 16 ?
PurchasePrice 37 12
OrderQty 49 5 ?
ItemDueDate 54 8 ?
ReceivedQty 62 5 ?
END
N;
COMMIT WORK;
!echo Table OrderItems successfully loaded!;
LOAD FROM EXTERNAL sampledb/Vendors TO PurchDB.Vendors
VendorNumber 3 4
VendorName 7 30
ContactName 39 30 ?
PhoneNumber 71 12 ?
VendorStreet 88 30
VendorCity 120 20
VendorState 142 2
VendorZipCode 146 5
VendorRemarks 152 60 ?
END
N;
COMMIT WORK;
!echo Table Vendors successfully loaded!;
LOAD FROM EXTERNAL sampledb/Clubs TO RecDB.Clubs
ClubName 1 15
ClubPhone 25 4 ?
Activity 35 18 ?
END
N;
COMMIT WORK;
!echo Table Clubs successfully loaded!;
LOAD FROM EXTERNAL sampledb/Members TO RecDB.Members
MemberName 1 20
Club 25 15
MemberPhone 45 4 ?
END