An Overview of Informix 4GL
- Describe Informix 4GL products
- List and describe the components of a 4GL program
- Use the I-4GL Programmer's Environment to perform application development tasks
- Use command-line commands to compile programs
The I-4GL Programming Language
- Write programs using I-4GL syntax
- Display messages and prompt for information in an application
- Create menus in an application
Utilities
- Create a Help file
- Create and use forms
- Display a form
- Open a new window to display a form
Informix Data Types
- List and describe the various Informix data types available
- List Informix data types that are not supported by Informix 4GL
Programming concepts
- Define the appropriate variables for your program
- Understand the scope of program variables
- Know which data types can be used to define a variable in your program
Entering Application Data
- Use the INPUT statement to enter user data into program variables
- Modify input data using INPUT statement clauses
- Use the INSERT statement to add data to a database
Event Handling
- Use an SQLCA record to identify errors and warnings
- Use the WHENEVER ERROR statement to manage error handling
- Use the DEFER INTERRUPT statement to identify and respond to errors during data entry
Query Handling
- Use basic SELECT statements in a 4GL application
- Verify that data entered is valid
Using Cursors
- Use cursors in a 4GL application
- Explain the purpose of transactions and implement them in an application
- Use scroll cursors
Query-by-Example
- Implement query by example in a 4GL application
Deleting and updating rows
- Lock rows to be modified using a FOR UPDATE cursor
- Delete rows from a table in a 4GL application
- Update rows in a 4GL application
Optimizing applications
- Use the PREPARE command to prepare frequently used statements and EXECUTE when it is time to run them
- Use a SCROLL cursor on a primary key to create an index that can be used by another cursor
Arrays
- Create a use a form that uses an array
- Create an input array to use for data entry
- Describe the various input array options
- Display array data in a regular or pop-up window
Reports
- Create a report driver
- Define and generate the report
- Format the report output
Informix 4GL applications as Web services
- Define Web Service and Service-Oriented Architecture
- Describe the process of deploying a 4GL application to a Web service
- Configure the 4GL development environment for Web services
- Use the 4GL tools to manage components, compile, and deploy functions as Web services
Welcome
Unit 1: An overview of Informix 4GL
- Topic 1: Informix 4GL and the Informix toolset
- Topic 2: Basic components of I-4GL
- Exercise 1
- Topic 3: The I-4GL user interface
- Topic 4: Building a 4GL application
- Topic 5: Compiling the application
- Exercise 2
Unit 2: The Informix 4GL programming language
- Topic 1: Procedural logic
- Topic 2: Screen interaction statements
- Topic 3: The MENU statement
- Exercise 3
Unit 3: Utilities
- Topic 1: Creating a help file: The mkmessage utility
- Exercise 4
- Topic 2: Creating and using forms
- Exercise 5
- Topic 3: Displaying forms
- Topic 4: Opening windows to display forms
- Exercise 6
Unit 4: Informix data types
- Topic 1: Character data types
- Topic 2: Numeric data types
- Topic 3: Date and Time data types
- Topic 4: Other types
Unit 5: Programming concepts
Unit 6: Entering application data
- Topic 1: The INPUT statement
- Exercise 8
- Topic 2: Using clauses with the INPUT statement
- Exercise 9
- Topic 3: The INSERT statement
- Exercise 10
Unit 7: Event handling
- Topic 1: The SQLCA record
- Topic 2: Trapping errors with the WHENEVER statement
- Exercise 11
- Topic 3: The DEFER INTERRUPT statement
- Exercise 12
Unit 8: Query handling
- Topic 1: SELECT statement review
- Topic 2: Verifying data in I-4GL
- Exercise 13
Unit 9: Using cursors
- Topic 1: An overview of cursors
- Topic 2: Transactions
- Exercise 14
- Topic 3: Using scroll cursors
- Exercise 15
Unit 10: Query-by-Example
- Topic 1: The CONSTRUCT statement
- Topic 2: Preparing the query
- Exercise 16
Unit 11: Deleting and updating rows
- Topic 1: Row locking: FOR UPDATE cursors
- Topic 2: Deleting rows
- Exercise 17
- Topic 3: Updating rows
- Exercise 18
Unit 12: Optimizing applications
- Topic 1: Using PREPARE to optimize applications
- Exercise 19
- Topic 2: Scroll cursors and stale data
- Exercise 20
Unit 13: Arrays
- Topic 1: Forms that use arrays
- Exercise 21
- Topic 2: The INPUT ARRAY statement
- Exercise 22
- Topic 3: INPUT ARRAY clauses
- Topic 4: Displaying arrays
- Topic 5: Pop-up windows
- Exercise 23
Unit 14: Reports
- Topic 1: Creating a report driver
- Exercise 24
- Topic 2: The REPORT function
- Exercise 25
- Topic 3: Built-in formatting functions
- Topic 4: Two reports from one SELECT
- Topic 5: Using variables to name output files
Unit 15: Informix 4GL applications as Web services
- Topic 1: Introduction to Service Oriented Architecture (SOA) and Web services
- Topic 2: Configuring a system for Web services
- Topic 3: Using I-4GL Web service utilities
- Exercise 26