Re: Informix SE on Solaris, using ACE report writer...
http://www.informix.com/answers/english/pisql.htm
From: mars1972@my-deja.com
>
>In article <8lmds2$nai$1@news.xmission.com>,
> "Obnoxio The Clown" <obnoxio@hotmail.com> wrote:
> >
> > From: Carlos Benjamin <benj@firstlinux.net>
> > >
> > >--- "Obnoxio The Clown" <obnoxio@hotmail.com>
> > > > wrote:
> > > >From: Carlos Benjamin <benj@firstlinux.net>
> > > >>
> > > >>--- mars1972@my-deja.com
> > > >> > wrote:
> > > >> >Unless I'm missing something, you can only have one SQL
>statement in
> > >an
> > > >> >ACE report. What you might want to do is create a stored
>procedure
> > >that
> > > >> >figures out all the records you want and call the stored
>procedure in
> > > >> >the SQL section of the ACE report.
> > > >> >
> > > >>
> > > >>I believe you can do multiple SQL's in an ACE report. You could,
>for
> > > >>instance, in the ON EVERY ROW portion of the report select some
>info
> > >from a
> > > >>table based on one of the already selected rows (to get a
>description
> > > >>perhaps).
> > > >
> > > >From the ISQL reference manual, page 4-37:
> > > >
> > > >"The SELECT section begins with the SELECT keyword. This keyword
> > >introduces
> > > >both the SELECT section and the first SELECT statement. Other
>SELECT
> > > >statements can follow the first'each must begin with the SELECT
>keyword.
> > >All
> > > >SELECT statements, except for the last, must end with a semicolon.
>(If> > >there
> > > >is only one SELECT statement, it does not require a semicolon.) The
> > >SELECT
> > > >section ends with the END keyword. All but the last SELECT
>statement must
> > > >have an INTO TEMP clause."
> > >
> > >Thank you for that SELECT passage.
> >
> > I hallways do my best.
> >
> > > >I didn't have to read this to know it, but I did have to read it to
>prove
> > > >it. :-)
> > >
> > >To prove you could read?
> >
> > That too.
> >
>
>That explains it then. I can read, (sort of) but I've never found any
>doc on ACE. I even called Informix and they told me they didn't print
>it anymore...
>
>________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at
>http://www.hotmail.com
> >
> >
>
>--
># unrm /
>ksh: unrm: not found
># man cpio
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com