Re: sql-question

Of course SQL is a language -- Structured Query Language -- the language of relational databases. Tom Vic Glass wrote: > 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

Tom Grenier wrote: > Of course SQL is a language -- Structured Query Language -- the language of relational > databases. However, you probably understand my drift ... > > > Tom > > Vic Glass wrote: > > > 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