Re: flat file extracts

From: Walter T Rejuney <BlueSax@Unforgetable.com> > >I am normally a Oracle DBA and developer, but I have a need to do some >extremely basic work with an Informix database. Hello! >As near as I can determine the version of Informix I'm dealing with is >7.2 and it is running on a Sun Ultra-5 workstation. > >Basically what I'm doing is this: > >dbaccess mydb <<-sqlEOF >extract.log 2>&1 >unload to mydata.dat select lname,fname from users>sqlEOF > >It works fine. My data is extracted and it appears in the data file the >way I want. However, the log file that gets created contains messages >like "Database selected" "50 row(s) unloaded" and "Database closed". I >don't care about these messages. I'd like to eliminate them. With >Oracle's sqlplus I would do a combination of using -s on the command >line and "set feedback off" inside the script to turn off extraneous >messages. Is there any equivalent to this with dbaccess? Lose the 2>&1 ? >Beyond that, does anyone know of a url where I can find documentation on >dbaccess so that I don't have to ask questions like this here unless I >get really stuck on some issue? http://www.informix.com/answers/ ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com