RE: embedded SQL Precompiler

["Mangavalli, Ramanujam" <RamM@xxxxxxxxxxx>]

Rob,

GROUP BY with ROLLUP, GROUP SETS, CUBE... etc are not on the iSeries. You
can surely get around that, but it would be a lot simpler to have these.

-----Original Message-----
From: rob@dekko.com [mailto:rob@dekko.com]
Sent: Thursday, February 21, 2002 10:22 AM
To: rpg400-l@midrange.com
Subject: RE: embedded SQL Precompiler



To the best of my knowledge there is nothing we are missing, SQL wise, in
the precompiler that is in UDB/400 itself.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    "Phil"
                    <sublime78ska@yah       To:     <rpg400-l@midrange.com>
                    oo.com>                 cc:
                    Sent by:                Fax to:
                    rpg400-l-admin@mi       Subject:     RE: embedded SQL
Precompiler
                    drange.com


                    02/20/2002 06:03
                    PM
                    Please respond to
                    rpg400-l






Are we missing any database functionality?

Phil



> -----Original Message-----
> From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On
> Behalf Of rob@dekko.com
> Sent: Wednesday, February 20, 2002 5:33 PM
> To: rpg400-l@midrange.com
> Subject: RE: embedded SQL Precompiler
>
>
>
> There are numerous things that the precompiler doesn't support that
> standard RPG does.  The RPG developers are doing their best to
> come up with
> workarounds.
> Example:  Nested /COPY's are not supported.  Workaround is to use
> /INCLUDE.
>
> Then there are enhancements which would be nice, like not having to
> physically have your
> DECLARE ...
> OPEN...
> FETCH ...
> CLOSE...
> in order.  Even though they logically don't get called out of order.
(Can
> you say "subroutine"?)
>
> Rob Berendt
> --
> "
>


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.





_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.