You receive the following benefits from accessing (at declaration time) a database that has similar characteristics to the database that your code will access at run time:
The retrieve feature creates record items that each have the same name (or almost the same name) as the related table column.
You cannot retrieve a view that is defined with the DB2 condition WITH CHECK OPTIONS.
For further details on using the retrieve feature, see Retrieving SQL table data. For details on naming, see Setting preferences for SQL retrieve.
To access a database at declaration time, specify connection information in a preferences page, as described in Setting preferences for SQL database connections.
Related concepts
Dynamic SQL
Logical unit of work
resultSetID
Related tasks
Retrieving SQL table data
Setting preferences for SQL database connections
Setting preferences for SQL retrieve
Related reference
add
close
Database authorization and table names
Default database
delete
execute
File and database (system words)
get
get next
Informix and EGL
open
prepare
replace
SQL data codes and EGL host variables
SQL item properties
SQL record internals
SQL record part in EGL source format
Testing for and setting NULL
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.