Embedded SQL and ODBC have advantages particular to them. Some of the advantages
of embedded SQL are:
- Static SQL usually provides better performance than dynamic SQL. It does
not have to be prepared at run time, thus reducing both processing and network
traffic.
- With static SQL, database administrators have to grant users access to
a package only rather than access to each table or view that is used.
Some of the advantages of ODBC are:
- It provides a consistent interface regardless of what kind of database
server is used.
- You can have more than one concurrent connection.
- Applications do not have to be bound to each database on which they execute.
Although PL/I for Windows does this bind for you automatically, it binds automatically
to only one database. If you want to choose which database to connect to dynamically
at run time, you must take extra steps to bind to a different database.
|
This information center is powered by Eclipse technology. (http://www.eclipse.org)