As shown in the next table, EGL-generated code can access a relational database on any of the target systems.
Target System | Support for access of relational databases |
---|---|
AIX, iSeries, Linux, Windows 2000/NT/XP, UNIX System Services | JDBC provides access to DB2 UDB, Oracle, or Informix(R) |
As you work on a program, you can code SQL statements as you would when coding programs in most other languages. To ease your way, EGL provides SQL statement templates for you to fill.
Alternatively, you can use an SQL record as the I/O object when you code an EGL statement. Using the record in this way means that you access a database either by customizing an SQL statement provided to you or by relying on a default that removes the need to code SQL.
In either case, be aware of these aspects of EGL support for SQL:
select empnum, empname from employee where empnum >= :myRecord.empnum for update of empname
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.