Prerequisites:
You should complete:
IBM Informix Relational Database Design (CF180MY)
IBM Informix Structured Query Language (FN613MY) or have equivalent knowledge.
You should also have programming experience and knowledge of the vi text editor. Experience using UNIX is recommended.
Audience
This is an intermediate course for application developers, database and system administrators, project leaders, and technical support individuals.
Overview
Get an introduction to the powerful features of Informix 4GL, a complete fourth-generation application development language. Using Informix 4GL, build an integrated application that features easy-to-use menus, data entry screens, reports, and online help, all with significantly less code than conventional programming languages require.
Skills Taught:
Develop custom applications using Informix 4GL
Create custom menus
Create custom data entry forms
Use the Y2K CENTURY attribute
Effectively use SQL statements in your application
:: Course L1008MY ::
Integrate online help facilities into your application
Incorporate error-handling routines into your application
Use transactions in your application
Produce custom reports
Use screen arrays
Insert multiple rows using arrays
Execute dynamic SQL statements
Lock database rows during updates
Course Outline:
The MENU statement
Creating a help file: the mkmessage utility
Forms in IBM Informix 4GL
Displaying forms and windows
Data types in IBM Informix 4GL
Defining program variables
The INPUT statement
Using clauses with the INPUT statement
The INSERT statement
The SQL Communication Area (SQLCA) record
Trapping errors with the WHENEVER statement
Trapping user entered interrupts: the DEFER INTERRUPT statement
A review of the SELECT statement
Verifying data in IBM Informix 4GL
:: Course L1008MY ::
An overview of cursors
Transactions in IBM Informix 4GL
Using scroll cursors
Query by example: the CONSTRUCT statement
Row locking: FOR UPDATE cursor
Deleting rows in IBM Informix 4GL
Database updates in IBM Informix 4GL
The PREPARE statement for optimization
Scroll cursors and stale data
Forms that use arrays
The INPUT ARRAY statement
Clauses using INPUT ARRAY
Displaying arrays and pop-up windows
Reports in IBM Informix 4GL: creating a report driver
The REPORT function
Advanced report concept: two reports from one SELECT
Advanced report concept: using variables to name output files
Stored procedure conflict resolution
This is a version-specific reference outline. Confirm the current syllabus and delivery arrangements with EIEIO.