From: maint72@saad-emh1.ARMY.MIL (Michael Gordon)
Newsgroups: comp.databases.informix
Subject: SQL Ace Report Writer.
Date: 26 Aug 92 00:58:02 GMT
Reply-To: maint72@saad-emh1.ARMY.MIL (Michael Gordon)
X-Informix-List-ID: <list.1402>

Thank you all for your interest and suggestions.  The following
may help clear up some problem areas in understanding what I
asked in the first place.
 
But, first you should understand that I believe the Informix SQL
v. 2.10.06 for MS-DOS will not support Ace Reports being sent to
MD-DOS system programs.  Some of my local Informix programmers
have so informed me yesterday, however, if anyone has created a
method or work-around I would like to see it.
 
 
In article <9381@emory.mathcs.emory.edu>
maint72@saad-emh1.ARMY.MIL (Michael Gordon) writes:
>Good Morning!
>I have discovered a problem with Informix SQL v 2.10 Ace
Report Writer.
>
>The problem is with Ace on the PC, in the OUTPUT block of the
source code
>the REPORT TO instruction works well in sending the formated
text/data to
>a "file" or to the PRINTER.  However, the reference manual
states that a
>key word "PROGRAM" will send the output to a SYSTEM COMMAND. 
This should
>work like the Unix " REPORT TO PIPE 'cat >
/usr2/login/subdirectory/filename".
>
>THE PROGRAM KEY WORD DOSE NOT WORK AT ALL, NOT IN ANY
CONFIGURATION I CAN
>COME UP WITH.
I've *never* heard of a PROGRAM keyword.  I just re-checked
the doc (2.10.06)
and it says that "filename" or PRINTER are the only options. 
Is this Informix
documentation that you are looking at, or some third-party
doc?
>Has anyone on the Net tried to use this PROGRAM keyword to
successfully sen
>the output of a report to a MS-DOS system command, .exe,
.com, .bat?
I don't think such a thing has ever been supported.  Best bet
is to write to
a file and then use the file as redirected input to the
<PROGRAM>.
>Thanks for even reading this.
>       Michael S. Gordon
>       Foreman, Gyroscope Section
>       Avionics Division 
--
Alan Denney      aland@informix.com     
{pyramid|uunet}!infmx!aland
I'm Pro-Anarchy...   and I Vote!
 
Alan,
 
This PROGRAM key word is directly out of the Informix SQL v.
2.10.06 for MS-DOS, page 5-29.  To quote the line beneth the
heading "PRINTER"; 'program    is the name of a system
command'.
 
Dose this not read as if 'program' means a DOS System Command?
 
If "PRINTER" will sent the report output to the system
printer, why won't other system commands work as well?
 
I really don't expect a lot of positive answers from this
message, because I know MS-DOS dose not work like Unix.  But,
thanks for trying.
 
 
 


					Michael S. Gordon
					Foreman, Gyroscope Section
					Avionics Division 

 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 *                                                                           *
 *  Michael Gordon                           Sacramento Army Depot           *
 *  Foreman, Gyroscope Section               Directorate For Maintenance     *
 *  E-Mail: maint72@saad-emh1.army.mil       Attn: SDSSA-MAV-320             *
 *  DSN:    839-2367                         Michael S. Gordon               *
 *  Comm.:  (916) 388-2367                   Sacramento, CA 96813-5036       *
 *                                                                           *
 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 
Newsgroups: comp.databases.informix