EGL Server Guide for iSeries


Preparing a DB2 application

When you specify an SQL table name in EGL, you can enter the table name on the Table Specification window using either the SQL naming convention of collection.tablename or the iSeries SYSTEM naming convention of collection/tablename. Whichever format you use as the standard to qualify table names, tailor the OPTION parameter on the FDAPREP script to be *SQL (collection.tablename) or *SYS (collection/tablename). The default naming convention is *SQL.

When you tailor the FDAPREP script, ensure that the *APOSTSQL and *QUOTE values are part of the OPTION parameter.


[ Top of Page | Previous Page | Next Page | Table of Contents ]