RE: embedded SQL Precompiler

I am thinking that his question dealt with the concern about the
precompiler lagging behind if there is something that you can do with the
SQL CLI's that cannot be done with the precompiler.  I am not aware of any.

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



                    "Mangavalli,
                    Ramanujam"              To:     "'rpg400-l@midrange.com'" 
<rpg400-l@midrange.com>
                    <RamM@Mvmills.com       cc:
                    >                       Fax to:
                    Sent by:                Subject:     RE: embedded SQL 
Precompiler
                    rpg400-l-admin@mi
                    drange.com


                    02/21/2002 10:36
                    AM
                    Please respond to
                    rpg400-l






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.
_______________________________________________
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.