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.
Supported SQL Database Managers
The following table provides a list of the SQL databases that EGL supports.

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

Supported SQL Database Managers

The following table provides a list of the SQL databases that EGL supports.

To create a connection, the New Connection wizard requests some or all of the information in the right column. This information is provided so that you can obtain the right information from a database administrator, if necessary. For more information about these connection fields, see Fields in the New Connection wizard.

Table 1. Supported databases
Database Manager	Versions	Setup Information
Cloudscape®	5.1	JDBC driver JDBC driver class Class location Connection URL User ID Password
DB2® UDB	V10.1 and higher	JDBC driver Host Port number JDBC driver class Class location Connection URL User ID Password
DB2® UDB iSeries®	V7R1 and higher	JDBC driver JDBC driver class Class location Connection URL User ID Password
DB2® UDB zSeries®	12.1 and future fix packs	JDBC driver Host Port number JDBC driver class Class location Connection URL User ID Password
Derby	10.9 and higher	JDBC driver Database location JDBC driver class Class location Connection URL User ID Password
Informix®	9.2, 9.3, 9.4, 10.0	JDBC driver Database Host Port number Server JDBC driver class Class location Connection URL User ID Password
MySQL	8.0 and higher	JDBC driver Database location JDBC driver class Class location Connection URL User ID Password
Oracle	12.1 and higher	JDBC driver SID Host Port number JDBC driver class Class location Connection URL Catalog User ID Password
PostgreSQL	14 and higher	JDBC driver Database location JDBC driver class Class location Connection URL User ID Password
SQL Server	2014 and higher	JDBC driver Host Port number JDBC driver class Class location Connection URL User ID Password