Re: Informix query

From: David Stes <stes@pandora.be> > >Obnoxio The Clown wrote: > > > > From: "Marco Meoni" <mmeoni@usl4.toscana.it> > > > > > >How can I execute Informix query from unixware script? > >You can do this with 'sqlcmd', like in > > foo=`sqlcmd -d mydb -e "select count(*) from mytab;" 2>&1` > >Sqlcmd is available from ftp://ftp.iiug.org/pub/ > >I believe most recent version is 57. Look for a file sqlcmd-57.tar.gz. > > > >I work with Informix Online 7.30 under Sco Unixware 7.0. > > > > > >I used the sacego utility with Informix online 7.30 under Digital Unix >4.0, > > >but this utility doesn't exist in Unixware. > >No need to use sacego for this. Perhaps he's not expressing himself clearly, and he uses sacego for ACE reports? In which case I believe it is a fairly fundamental requirement... > > It does exist, it's part of Informix-SQL. You should have cross-graded / > > bought / whatevered it for the new platform. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com