You can create an EGL Library type with a few
keystrokes. In an important variation, you can invoke the data-access
wizard, which automatically creates data-access functions for
each database table that you specify.
The steps are as follows:
- Right click a package and do the fastest process available:
- Click ; or
- Click , expand EGL, and click Library.
The New Library wizard is displayed.
- Specify the file name.
- If you want a Library type for general use, click Basic and
then Finish.
- If you want a Library type to provide access to a properties file
from a Rich UI handler, click Rich UI Properties and then Finish.
- Alternatively, if you are invoking the data-access wizard, do
as follows:
- Click Library from a database and then Next. The
Database tables page is displayed.
- Use the topmost dropdown menu to select an existing connection,
or click Create new connection and work through the subsequent
pages to create a connection that will provide access to the database
at development time.
Note: If you save connection detail that you then
want to change, go to the Data Source Explorer view:
- To access the view in the Database Development perspective, click and, at the Open Perspective
page, click Database Development. To add the
view to your current perspective instead, click , expand Data Management, and
click Data Source Explorer.
- To update the connection details, right click the connection;
click Properties; make the required changes, particularly in
the JDBC connection properties pane; and click OK.
- Select one or more tables. The output code provides access to
each table individually and does not include logic for table joins.
- If you want to include a schema name wherever a table name is
referenced, click Qualify table names with schema.
- If you want to create an EGL deployment descriptor entry that
will be referenced by a binding variable in the code that is being
created for you, click Create SQL database binding in the development
deployment descriptor.
- Click Next. The Summary page is displayed, and you can
review any of several files that are listed in the Preview file combo
box.
- Click Finish.
See also the following topics: