RE: embedded SQL Precompiler

[rob@xxxxxxxxx]

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
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    J Michael Smith
                    <JMichael.Smith@a       To:     "'rpg400-l@midrange.com'" 
<rpg400-l@midrange.com>
                    rch.com>                cc:
                    Sent by:                Fax to:
                    rpg400-l-admin@mi       Subject:     RE: embedded SQL 
Precompiler
                    drange.com


                    02/20/2002 04:07
                    PM
                    Please respond to
                    rpg400-l






CLI API's allow you to access multiple systems without having to create a
*SQLPKG.

In a single system environment, probably not a "big deal".  In multi system
environment this factor could be important.

I have used both embedded SQL and the SQL CLI api's and somewhat agree with
"coding is simpler using embedded SQL".

Could someone explain the issue with using the "precompiler"... so that a
simple mind(like mine) can understand it.

Michael Smith

-----Original Message-----
From: Bob Slaney [mailto:rjslaney@us.ibm.com]
Sent: February 20, 2002 09:49 AM
To: rpg400-l@midrange.com
Cc: rpg400-l@midrange.com; rpg400-l-admin@midrange.com
Subject: Re: embedded SQL Precompiler


Phil, I looked at the CLI APIs several years ago, and I think they are far
more complex to use than embedded SQL.  You basically are writing all the
calls to the DB to perform everything from file declaration, file open,
etc. I cannot comment on performance. I would think that well written CLI
code will perform well. But, as I said, the coding is much simpler using
embedded SQL.

Even though I am very disappointed in the SQL Precompiler, I'll live with
it rather than write CLI calls.

In closing, I hope that I won't have to live with the current SQL
Precompiler any longer than necessary.

Bob

Bob Slaney/Atlanta/IBM@IBMUS (Lotus Notes)
Internet id: rjslaney@us.ibm.com
VM id: DALVM1.RJSLANEY@VM

Tieline  445-7374 Direct (770)835-7374
FAX tie 445-7232 Direct (770)835-7232
IBM Learning Services
iSeries Courseware Developer
IBM Corp.
3200 Windy Hill Road
Atlanta, GA 30339
Internal Zip WG08C



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


                      02/20/2002 10:01
                      AM
                      Please respond to
                      rpg400-l





>
> ALL Enhancements to the DB will be in SQL.  UDF's
> UDT's, EVI's, Blobs,
> Clobs, DataLinks, etc
>
> And they don't put their money where their mouth is.
>
> NO new enhancements to the Native DB access
> methods(ie Chains, Reads, Etc)
> All enhancements would be taken advantage of by SQL,
>
> BUT They are giving lip service to helping us REALLY
> USE the new
> enhancements.
>

Maybe they want us to use the new support in RPG to
call java, and use jdbc.  :-)

The point of my question, though, is Does it buy me
anything to use the api's or is the result the same?
It looks like the api's actually could produce slower
performance.

Phil

__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.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.