Path: utzoo!attcan!uunet!peregrine!elroy!ames!husc6!cmcl2!phri!marob!daveh
From: daveh@marob.MASA.COM (Dave Hammond)
Newsgroups: comp.databases
Subject: output redirection in Informix 2.1 SQL
Keywords: Informix, SQL, redirection
Message-ID: <346@marob.MASA.COM>
Date: 1 Aug 88 21:56:42 GMT
Reply-To: daveh@marob.UUCP (Dave Hammond)
Organization: 18th Street Construction Co NY NY
Lines: 23


I would like to redirect the standard output of Informix 2.1 SQL from
the isql command line directly, e.g. something on the order of:

select * from table  [ > save_file ]     or:
select * from table  [ | command   ]

I know I can do this from within a shell script and redirect output
that way, but this involves reloading and initialising isql for each
statement to be redirected. About the only thing I've come up with is
tee'ing a log file, editing the log, etc (which s[t,u].*ks :-)

Any suggestions ?

Dave Hammond                                                /dsix2!daveh
  UUCP: {uunet | rutgers | spl1 | ...}!{masa.com | hombre}!<
DOMAIN: dsix2!daveh@masa.com                                \marob!daveh
----------------------------------------------------------------------------
-- 
Dave Hammond                                                /dsix2!daveh
  UUCP: {uunet | rutgers | spl1 | ...}!{masa.com | hombre}!<
DOMAIN: dsix2!daveh@masa.com                                \marob!daveh
-------------------------------------------------------------------------