RE: flat file extracts

> I am normally a Oracle DBA and developer, but I have a need to do some > extremely basic work with an Informix database. Thats OK we won't hold it against you > > 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 dbaccess mydb <<-sqlEOF >extract.log 2>/dev/null > 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? > > 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? > The contents of this e-mail are confidential to the ordinary user(s) of the mail address(es) to which it was sent and may be legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or use of it, or any part of it, in any form whatsoever, and any actions taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.