Re: shell to perform dbaccess
Posted in 1997
Teresa Crowl (tjc@umbra.pvh.org) wrote:
: Does anyone know how I would write a shell program to
: take sql statements from a file and execute them
: via dbaccess?
: ie:
: file name: adt_transactions
: data is:
: insert into patient_census VALUES("04/04/1997","A04","BC","3045","A")
: insert into patient_census VALUES("04/04/1997","A04","WC","4045","A")
: insert into patient_census VALUES("04/04/1997","A04","BC","3047","B")
: .
: .
: .
insert semicolons at the end of each line
dbaccess your_database_name adt_trans
: TIA
: Teresa Crowl
: tjc@umbra.pvh.org
--
---------------------------------------------------------------------------
Joe Lumbley(jlumbley@netcom.com)
---------------------------------------------------------------------------