Re: sql-question

Vic Glass wrote: > (...) > #!/bin/sh > dbaccess db <<-! > unload to tbl.unl select * from tbl order by fld> ! If you're SQL-challenged, this part is halfway correct. > > vi tbl.unl # during the vi session, find and delete the desired > row(s) > You might as well do this part in dbaccess. If you absolutely have to take the data out of the database, try running a sort tbl.unl|uniq instead. Then at least it stands a chance of working. -mka Michael Ackerbauer SP System Test

ackerbau@us.ibm.com wrote: > Vic Glass wrote: > > > (...) > > #!/bin/sh > > dbaccess db <<-! > > unload to tbl.unl select * from tbl order by fld> > ! > > If you're SQL-challenged, this part is halfway correct. Actually its shell and vi enabled ... most DBAs that I've encountered have minimal programing and UNIX skills ... are you inferring that SQL is a language? > > > > > > vi tbl.unl # during the vi session, find and delete the desired > > row(s) > > > > You might as well do this part in dbaccess. > > If you absolutely have to take the data out of the database, try running a sort > tbl.unl|uniq instead. Then at least it stands a chance of working. > > -mka > > Michael Ackerbauer > SP System Test