About Trainer

  • 12 years of Informix experience
  • IBM Informix Certified
  • Working as Lead Developer
  • Sound Technical skills

About Informix 4GL

 
 
 
 
ONLINE TRAINING IN IBM INFORMIX 4GL DEVELOPMENT BY OUR REALTIME/CERTIFIED PROFESSIONALS

Course Pre-requisites:

Lab setup: RHEL 32/64 bit

Training Material:

  • Class PPT’s (Soft Copy)
  • Class recordings (optional)

IBM INFORMIX 4GL ONLINE TRAINING COURSE CONTENT:

Course Outline

  • What is Informix 4GL?
  • Informix-4GL basics
  • Informix-4GL Statements
  • Functions, operators
  • Forms, Cursors, Arrays
  • Reports

Informix 4GL basics

  • What is Informix-4GL?
  • Two implementations of INFORMIX-4GL
  • Difference between C Compiler and RDS versions
  • Five phases of I4GL compilation process
  • Phases of RDS program execution
  • Walk-thru of RDS, I4GL Menus
  • I4GL/RDS programmers environment
  • Creating programs through menus
  • Creating programs at command line
  • Lab: Informix-4GL Installation, Walk-thru I4GL, RDS Screens
  • Lab: Compiling applications using I4GL, RDS environments

Informix 4GL Statements

  • Datatypes, Expressions, and Reserved words
  • Informix-4GL Statements
  • Interacting with users using
  • Ring menus
  • Screen Forms
  • 4GL Windows
  • On-Line Help
  • Nested and Recursive Statements
  • Exception handling
  • Compile time errors and warnings
  • Runtime errors and warnings
  • Changes to 4GL Error handling
  • Error handling with SQLCA
  • Lab: Creation of 4GL Windows, Ring menus; Understanding SQLCA record
  • Lab: Managing multiple windows

4GL Statements, Functions, and Operators

  • The 4GL Statement set
  • SQL Statements
  • 4GL Statements
  • Types of SQL statements
  • 4GL statements
  • CALL
  • CASE
  • CLEAR
  • ERROR
  • EXIT
  • FOREACH
  • PROMPT
  • UNLOAD
  • MESSAGE
  • WHENEVER, etc
  • Built-in Functions and Operators
  • Built-in 4GL programs
  • Built-in and External SQL Functions and Procedures
  • C Functions
  • ESQL/C Functions
  • Programmer-Defined 4GL Functions
  • Invoking Functions
  • Built-in functions such as DOWNSHIT, CURRENT, DATE, etc
  • Lab: Informix-4GL statements, Functions

Screen Forms, Cursors, Arrays

  • Screen Forms
  • Structure of a Form specification file
  • Database Section
  • Screen Section
  • Tables Section
  • Attributes section
  • Instructions section
  • Default Attributes
  • Creating and compiling a form
  • Using PERFORM Forms in 4GL
  • Creating help file (mkmessage utility)
  • Defining and using Cursors for database programming
  • Forms that use Arrays
  • Lab: Displaying a Row in a form; Browsing a Scroll cursor; Using an Update cursor

Reports

  • The 4GL Report driver
  • The report definition
  • DEFINE Section
  • Output section
  • ORDER BY section
  • FORMAT section
  • FORMAT Section control blocks
  • AFTER GROUP BY
  • BEFORE GROUP BY
  • FIRST PAGE HEADER
  • ON EVERY ROW
  • ON LAST ROW
  • PAGE HEADER
  • PAGE TRAILER
  • Using statements in REPORT control fields
  • EXIT REPORT
  • NEED
  • PAUSE
  • PRINT
  • SKIP
  • Using C with Informix-4GL
  • Lab: Creating reports; Calling c code from 4GL program

 
 
 
 

Testimonials

  • The fact that they have a set format of teaching, which creates a schedule for a student, and a step-by-step process that covers the entire Netezza syllabus. I can surely assure eTraining provides a great help for Netezza curriculum.
    - Shannon D.

  • The BEST I liked about the tutors in eTraining is the amount of practical knowledge these guys have and the way they bring in the same to students perspective while Teaching. Glad I took DB2 course from eTraining.
    - Rubeena Khan

  • I found classes very helpful. What you Teach is AWESOME
    - Gopal