Creating an EGL Library type

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:
  1. Right click a package and do the fastest process available:
    • Click New > Library; or
    • Click New > Other, expand EGL, and click Library.

    The New Library wizard is displayed.

  2. Specify the file name.
  3. If you want a Library type for general use, click Basic and then Finish.
  4. 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.
  5. Alternatively, if you are invoking the data-access wizard, do as follows:
    1. Click Library from a database and then Next. The Database tables page is displayed.
    2. 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:
      1. To access the view in the Database Development perspective, click Window > Open Perspective > Other and, at the Open Perspective page, click Database Development. To add the view to your current perspective instead, click Window > Show > View > Other, expand Data Management, and click Data Source Explorer.
      2. 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.
    3. Select one or more tables. The output code provides access to each table individually and does not include logic for table joins.
    4. If you want to include a schema name wherever a table name is referenced, click Qualify table names with schema.
    5. 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.
    6. Click Next. The Summary page is displayed, and you can review any of several files that are listed in the Preview file combo box.
    7. Click Finish.
See also the following topics: