Re: Suppressing all messages from sacego and isql

> A while ago I posted this question but no suggestions worked completely. > I can suppress all messages from a command line "sacego" with the -s option, > but I can't suppress messages from a command line isql statement. > I have a shell script that calls several isql procedures and need > to suppress all screen output. Can anyone help me here? > Kate In a shell script using isql or dbaccess I like to send all output to a logfile with the following: isql database script >>/tmp/logfile 2>&1 This sends the unix stdout and stderr output to the file /tmp/logfile and the users don't see it, but you can for debugging. To get rid of all output use /dev/null instead of a logfile. The ">>/tmp/logfile" redirects standard output (&1) to a file and the "2>&1" redirects standard error (&2) to the same place as stdout. For ace reports use sacego report >>/tmp/logfile 2>&1 Regards - Lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # # Visit our Web page: http://www.access.digex.net/~lester # # Washington Area Informix User Group: http://www.access.digex.net/~waiug # #############################################################################