Informix 4GL Course

Free Informix 4GL for Developers Trial Course

I am testing a new online training format and would like your feedback on this course format.

See the Informix 4GL Course announcement here!

 

This course is for Informix 4GL software developers, analysts, designers, and programmers who will be developing database applications. This is a four-day course covering the topics listed below. Each topic will be covered in a session with a lecture and a hands–on lab.

An Overview of Informix 4GL

  • Informix 4GL Tools
  • Components of I-4GL
  • Building a 4GL application
  • Compiling the application
  • R4GL - Rapid Development System
  • Difference between Compiled and Interpretive 4GL

Informix 4GL Programming Language

  • Procedural logic
  • Screen interaction statements
  • The MENU statement

4GL Utilities

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

Informix 4GL Data Types

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

4GL Programming Concepts

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

Event and Error Handling

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

Query Handling

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

Using Cursors

  • Overview of cursors
  • SQL 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

  • PREPARE to optimize applications
  • Scroll cursors and stale data

Arrays

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

Reports

  • Creating a report driver
  • The REPORT function
  • Built-in formatting functions
  • Two reports from one SELECT

Debugging 4GL Programs

  • Using the Interactive Debugger
  • 4GL Trace files

Contact Us

This course is scheduled by request.

More Info