Re: Migrate from dbaccess to isql?

On Mon, 22 Feb 1999, wrote: >Hello All, > >I use `dbaccess DBNAME` in scripts quite often to access Online 5.07. >This was when the engine was on the local machine. > >Now I have upgraded to IDS 7.3 on a sun box, and have the apps running on >sco boxes. I have 4gl-rds, connect, and isql running on the sco boxes. But no DB-Access? Without a server on the SCO box, probably not, but it might be worth getting a server on there, just to get DB-Access. >I believe the utility that provides the functionality of dbaccess is isql. >I looked in the isql reference for command line options, like `isql -s >DBNAME -q options` but could not figure out how to do something simple >like: > >with dbaccess ># echo "SIMPLE SQL QUERY" | dbaccess DBNAME>with isql???? ># echo "SIMPLE SQL QUERY" | isql -s DBNAME -qn???????? isql dbname - Also supported by DB-Access, so you can make your program portable with: echo "SIMPLE SQL QUERY" | ${SQL_COMMAND:-dbaccess} DBNAME - You can set SQL_COMMAND to isql in the environment to use isql instead. Or consider SQLCMD from the IIUG web site. Yours, Jonathan Leffler (jleffler@informix.com) #include <wish/I/was/skiing.h> Guardian of DBD::Informix v0.60 (v0.61_02) -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn