Re: unload and load in 4GL programs ?
In article <54g4qr$dpe@cssun.mathcs.emory.edu> KENM@apscn.k12.ar.us ("Ken McCoy") writes:
>From: KENM@apscn.k12.ar.us ("Ken McCoy")
>Subject: unload and load in 4GL programs ?
>Date: 21 Oct 1996 11:28:27 -0400
>What is the best way to perform
>"UNLOAD TO file SELECT * from table" and
>"LOAD FROM file insert into table" in a 4gl program.
>Do you build shell scripts to use these options or what?
>Thanks in advance
>Ken McCoy
Ken:
You can have a statement in your 4gl like:
run "load.run"
The load.run script (in that directory) could say:
dbload -d dbname -c load.cmd -l load.log
Then also have a file called load.cmd which says:
file "pathname of the file to load from"
(
fld01 01-100
);
insert into tablename
(
fieldname
)
values
(
fld01
);
Hope this helps.
Sandy Livingston
slivi@interaccess.com