IBM INFORMIX 4GL is a fourth-generation application development and production environment that provides power and flexibility without the need for third-generation languages like C and COBOL. Informix 4GL Rapid Development System and Informix 4GL Interactive Debugger provide the optimal environment for developing applications, while Informix 4GL C Compiler provides high-performance application execution in the production environment.

• Training by Realtime Expert trainer
• Live Online Classes
• Free study material
• Online virtual Classes available in morning, evening and weekend

Prerequisties

• Previous programming experience
• Experience in using Structure Query Language (SQL) .

Duration

Online

• The format is 40% theory, 60% Hands-on.
• It is a 20 days program and extends up to 2hrs each.

Corporate

• The format is 40% theory, 60% Hands-on.
• It is a 5 days program and extends up to 8hrs each.

Classroom

• Private Classroom arrenged on request and minimum attendies for batch is 4.

Course Content

An overview of Informix 4GL

• Informix 4GL and the Informix toolset
• Basic components of I-4GL
• The I-4GL user interface
• Building a 4GL application
• Compiling the application

The Informix 4GL programming language

• Procedural logic
• Screen interaction statements
• The MENU statement

Utilities

• Creating a help file: The mkmessage utility
• Creating and using forms
• Displaying forms
• Opening windows to display forms

Informix data types

• Character data types
• Numeric data types
• Date and Time data types
• Other types

Programming concepts

Entering application data

• The INPUT statement
• Using clauses with the INPUT statement
• The INSERT statement

Event handling

• The SQLCA record
• Trapping errors with the WHENEVER statement
• The DEFER INTERRUPT statement

Query handling

• SELECT statement review
• Verifying data in I-4GL

Using cursors

• An overview of cursors
• Transactions
• Using scroll cursors

Query-by-Example

• The CONSTRUCT statement
• Preparing the query

Deleting and updating rows

• Row locking: FOR UPDATE cursors
• Deleting rows
• Updating rows

Optimizing applications

• Using PREPARE to optimize applications
• Scroll cursors and stale data

Arrays

• Forms that use arrays
• The INPUT ARRAY statement
• INPUT ARRAY clauses
• Displaying arrays
• Pop-up windows

Reports

• Creating a report driver
• The REPORT function
• Built-in formatting functions
• Two reports from one SELECT
• Using variables to name output files

Informix 4GL applications as Web services

• Introduction to Service Oriented Architecture (SOA) and Web services
• Configuring a system for Web services
• Using I-4GL Web service utilities