Re: Search by index vs. sequential scan

Quoting Jonathan Leffler <jleffler@earthlink.net>: > Clive Eisen wrote: > > Quoting "Mark D. Stock" <mdstock@MydasSolutions.com>: > >>Robin Munn wrote: > >>>Do you mean something like this? > >>> > >>> bash$ OPTCOMPIND=2 cat batch_query.sql | dbaccess > >> > >>Yes. Don't forget to export it though, dbaccess recognises the .sql > >>suffix, and what's that cat for?: > >> > >>OPTCOMPIND=2 export OPTCOMPIND; dbaccess - batch_query; unset OPTCOMPIND > > > > erm the form > > > > bash$ OPTCOMPIND=2 somecommand > > > > is the correct syntax to apply that environment variable for just one > command > > no export required > > > Correct, but the one command it applies to is 'cat' and the one > command that needs it is 'dbaccess'. True but I expected the 'reader' to infer bash$ OPTCOMPIND=2 dbaccess - batch_query -- Clive Eisen mob: +44 (0) 7957 626 324 email: clive@serendipita.com internet: http://www.serendipita.com