Re: execute SQL from command line?

mpeter wrote: > > > > > I am running SE 5.02, 4GL 4.12 on SCO 3.2v4.2 > > > > Is there a way to execute sql from the command line, or a program that > > you can pass the name of the database and a .sql file? > > > > TIA > > > > Matt Brickley > > > Hi, > u can execute sql from command line using isql .... > > isql -qr file.sql > > -file.sql contains valid sql commands including database command. > e.g: database test; > select * from chk;> -Peter. > mpeter.muc@sni.de The other way to execute sql from the command line is using dbaccess ..... dbaccess dbase file.sql -dbase is name of database and in file.sql need not to be command: database dbase; If in file.sql is command 'database dbase', so you can type dbaccess - file.sql -- Have a nice day Ing. Grejtak Lubomir Novitech Kosice mailto:grejtak_lubomir@novitech.sk http://www.novitech.sk