Application Development using IBM Informix 4GL

Prerequisites


You should complete:

* IBM Informix Relational Database Design (FN611)
* IBM Informix Structured Query Language (FN613)
* or have equivalent knowledge.

You should also have programming experience and knowledge of the vi text editor. Experience using UNIX is recommended.



Course outline


* IBM Informix 4GL and the IBM Informix toolset
* Basic components of IBM Informix 4GL
* IBM Informix 4GL programmer’s environment
* Procedural logic
* Screen interaction statements
* 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
* 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

Materiály v anglickém jazyce.

Podrobné informace o kurzu v anglickém jazyce.