ALLBASE/SQL Reference Manual (36216-90216)

Appendix C 637
Sample DBEnvironment
LOADTABS Command File
N;
COMMIT WORK;
!echo Table Members successfully loaded!;
LOAD FROM EXTERNAL sampledb/Events TO RecDB.Events
SponsorClub 1 15 ?
Event 20 30 ?
Date 50 10 ?
Time 62 8 ?
Coordinator 71 20 ?
END
N;
COMMIT WORK;
!echo Table Events successfully loaded!;
INSERT INTO PURCHDB.REPORTS VALUES ('Report1', 'FREE',
'< sampledb/Report1>! Report1');
COMMIT WORK;
!echo Table Reports successfully loaded!;
!echo Loading of databases is now done!;