Re: advantages of using embedded sql

I think you are confusing the concept of database independence with
different databases.

Database independence means that you are not locking your database schema or
what the tables look like into your applications. If you need to change it,
you can.

On the AS/400 you don't really have the concept of multiple databases. Since
the database is integrated into the operating system there is just one
database. You have multiple schema's (Libraries) but just one database.

If you have worked with something like SQL Server you can have multiple
databases. On the AS/400 there is just one.

If you have other AS/400's and you have purchased the right products from
IBM you can access those databases but I am sure that is more than anything
you are doing.

On Thu, Sep 8, 2011 at 4:40 AM, Dave <dfx1@xxxxxxxxxxxxxx> wrote:

2011/9/7 Alan Campin <alan0307d@xxxxxxxxx>

As to using embedded SQL, the reasons are legion but the absolutes number
one reason is database independence.

Thanks, this may be a dumb question : how exactly would my SQLRPGLE program
know that I wanted it to access a different database?
Thanks to all who answered.
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.