Welcome
Developing
Developing EGL applications
Enterprise Generation Language (EGL) is a programming language that you can use to focus on business problems instead of software technologies. Within the Rational® development environment, you can use EGL wizards and other tools to write complex applications with minimal effort.
EGL Programmer's Guide
The EGL Programmer's Guide covers using EGL within the Eclipse Integrated Development Environment (IDE), as well as some of the common programming tasks that EGL developers perform.
Accessing data with EGL code
SQL data
SQL (pronounced as three separate letters) is a language that communicates with a relational database management system (DBMS), which in turn controls a database that maintains business information in interconnected tables.
Setting preferences for SQL database connections

Overview
Getting started
Installing
Upgrading and migrating
EGL Code Accelerator for IBD
Developing
- Model driven development of EGL code
- Generating source code from UML models
  You can use transformations to create source code from a UML model. First you must create a transformation parameters file and then apply those parameters to a model.
- Generating the EGL Dependency Graph from EGL projects
- Generating Source Code from OpenAPI Documents
- Developing EGL applications
  Enterprise Generation Language (EGL) is a programming language that you can use to focus on business problems instead of software technologies. Within the Rational® development environment, you can use EGL wizards and other tools to write complex applications with minimal effort.
  - How to use this documentation
  - Additional information about EGL
    The most recent EGL documentation is in the IBM Business Developer documentation.
  - EGL Programmer's Guide
    The EGL Programmer's Guide covers using EGL within the Eclipse Integrated Development Environment (IDE), as well as some of the common programming tasks that EGL developers perform.
    - Introduction
      These topics explain the fundamentals of using EGL in the Eclipse IDE, as well as changes to the EGL language and IDE in this version.
    - Contents of an EGL application
      EGL applications contain projects, packages, folders, and files.
    - Properties
      Properties set specific options for parts. In general, you specify the properties when you create the part and then the properties are static. In certain circumstances, however, it is possible to change a property dynamically.
    - Annotating EGL Applications
      EGL developers can annotate their applications to indicate the version, authors as well as a general description.
    - Import and use statements
      Use the EGL import and use statements to expand the visibility of code elements.
    - Working with EGL code
    - Accessing data with EGL code
      - Common data access tasks
        You can use EGL to perform common data processing tasks such as reading and writing to files, without having to deal with implementation details.
      - SQL data
        SQL (pronounced as three separate letters) is a language that communicates with a relational database management system (DBMS), which in turn controls a database that maintains business information in interconnected tables.
        Creating an SQL database connection
        The New Connection wizard creates an SQL database connection that you can use either at design time or at run time.
        Supported SQL Database Managers
        The following table provides a list of the SQL databases that EGL supports.
        Using an SQL database connection at run time
        To use an SQL connection at run time, you must point to the connection from your project's build descriptor and, for EGL web projects, set options in the J2EE deployment descriptors based on information in the connection.
        Editing or deleting an SQL database connection
        Retrieving SQL table data
        Writing exits for EGL access of DB2®
        Creating a data access application
        EGL can create a simple data access application based on a database to which you are connected. The resulting application contains data parts, logic parts and (optionally) web pages that are based on one or more database tables.
        Working with SQL statements
        With EGL you can deal with explicit SQL code in your EGL program.
        Setting preferences for SQL database connections
        Setting preferences for SQL retrieve
        At EGL declaration time, you can use the SQL retrieve feature to create an SQL record from the columns of an SQL table.
      - DL/I data
      - Message Queues and Topics
      - iSeries® objects
        EGL provides a library and Record definitions to communicate with data queues and data areas on the iSeries®.
      - Working with bidirectional data
    - Transfer of control across programs
    - Developing segmented programs in EGL
      Different runtime environments have different considerations for developing segmented programs.
    - Developing EGL programs for the IMS™ environment
    - Developing EGL programs for the CICS® environment
      There are specific design and development considerations when creating EGL programs for CICS® for z/OS® and CICS for VSE.
    - Developing EGL programs for the VSE environment
      IBM Business Developer provides a Generation for VSE feature that you can use to generate EGL as COBOL source for the z/VSE® environment.
    - Developing programs for iSeriesC
      You can deploy EGL-generated COBOL programs targeted for the IBM® i environment.
    - Overview of EGL Logging for Java Application
    - Overview of EGL Rich UI
    - Services: a top-level overview
      The topics in this section describe service-oriented architecture (SOA) and related technologies, EGL support for SOA, and service-related procedures, with an emphasis on service access. For details about deployment, see “Introduction to EGL generation and deployment” and “Add web-service deployment entries in the EGL deployment descriptor.”
    - Generating source code from UML models
      You can use transformations to create source code from a UML model. First you must create a transformation parameters file and then apply those parameters to a model.
    - Building EGL Text User Interface applications
      A Text UI application presents a text-based user interface similar to that of a 5250 or 3270 terminal.
    - Creating reports with EGL
      EGL offers different ways to create reports, using external engines to generate the report contents.
    - Working with web transaction applications in EGL
    - Debugging EGL applications
    - EGL Unit Testing
    - z/OS Connect
  - EGL Generation Guide
    The EGL Generation Guide covers the process of converting EGL code to Java™ or COBOL source code, including the processes and the files involved. This section is intended for a developer who will generate or deploy EGL applications.
  - EGL Language Reference
    The EGL Language Reference covers the fundamental use of the language, including its concepts, syntax, and keywords. This volume is intended for a developer writing EGL applications with some experience in procedural programming.
  - Rational® COBOL Runtime Guide for zSeries®
    This manual provides information about customizing and administering the IBM® Rational® COBOL Runtime.
  - IBM Business Developer EGL Server Guide for IBM® i
    This manual provides information about customizing and administering EGL Server for IBM® i on the host.
  - Generation for VSE Feature Reference
    This reference manual provides z/VSE-specific information about developing and generating EGL programs in the VSE environment.
- Source code analysis with code review
  With code review, you can create configurations of coding rules for EGL source code. You can then run the configurations to check the source code for consistency with the rules.
- Responsive Design Support in IBD
  What is Responsive Design? Responsive design is an approach for creation of web pages that automatically scales its content and elements to match the screen size on which it is viewed. So, instead of designing multiple websites for different devices with variable screen sizes, we can design just one website that scales up or down automatically, to match the device it’s being viewed on.
- Containerizing an EGL RUI Application
Samples
Troubleshooting and support
EGL runtime error messages
Reference
Glossary
Using the help
Notices for IBM Business Developer documentation

Setting preferences for SQL database connections

In the workbench, you use database connections in two ways:

When you are developing your programs. For example, you need this connection when you use the EGL SQL retrieve feature; see Setting preferences for SQL retrieve.
When you are running or debugging your programs.

To create a new connection using the New Connection wizard, see Creating an SQL database connection, or use the following steps to set up or edit the connections:

Click Window > Preferences.
When a list of preferences is displayed, expand EGL, then click SQL Database Connections.
The currently selected connection in the Connection list is the default database for EGL in the workbench. You can switch between database connections, edit or delete the connections, and test the connections from this window.
To create a new connection, click New. For an explanation of the preference fields, see Fields in the New Connection wizard.
If you are using DB2® you might need to set the Secondary Authentication ID field. See "Secondary Authentication ID" in this topic.

You can clear or apply preference settings:

To restore default values, click Restore Defaults.
To apply preference settings without exiting the preferences dialog, click Apply.
If you are finished setting preferences, click OK.

Secondary Authentication ID

The secondary authentication ID is more commonly known as the secondary authorization ID. The meaning and use of the secondary authorization ID depends on the following conditions:

The DB2® platform you are using.
In some cases, the way that platform is configured.

To fully understand how a secondary authorization ID can be used for your environment, refer to your DB2® documentation.

Here are common examples of the secondary authorization ID:

For DB2® UDB, if you specify a secondary authorization ID, that ID is used as the default schema name for all SQL statements.
For DB2® on zOS, a secondary authorization ID is often mapped to a RACF® group. Access rights to DB2® objects are granted to the RACF® group and individual user IDs are added to the RACF® group. This technique minimizes work when your authorization requirements change. For example, if a new DB2® table is created, the system administrator can grant access to a RACF® group; all individuals belonging to that group then get read access, as long as they are using the secondary authorization ID.