This course is intended for application developers.
To maximize the benefits of this course, we require that delegates meet the following prerequisites:
- Previous programming experience.
- Experience in using Structure Query Language (SQL).
- Experience on a UNIX or Linux platform.
This course provides programmers with the basic tools they need for developing applications using the Informix 4GL programming language. Delegates will learn about the development and debugging tools available, and how to construct and compile applications in the 4GL Programmer's Environment. Attendees will be taught to create and use single and multi-row forms, generate reports, and manage transactions and cursors.
In lab exercises, delegates will create applications and add in additional functionality as new concepts are presented.
Course objectives include:
- Develop custom applications using Informix 4GL.
- Create custom menus.
- Create custom data entry forms.
- Effectively use SQL statements in your application.
- Incorporate error handling routines into your application.
- Integrate online help facilities 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.
- Deploy functions to Web services.
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.
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.
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.
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.
Use basic SELECT statements in a 4GL application.
Verify that data entered is valid.
Use cursors in a 4GL application.
Explain the purpose of transactions and implement them in an application.
Use scroll cursors.
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.
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.
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.
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.
Unit 1: An overview of Informix 4GL.
Topic 1: Informix 4GL and the Informix toolset.
Topic 2: Basic components of I-4GL.
Topic 3: The I-4GL user interface.
Topic 4: Building a 4GL application.
Topic 5: Compiling the application.
Unit 2: The Informix 4GL programming language.
Topic 1: Procedural logic.
Topic 2: Screen interaction statements.
Topic 3: The MENU statement.
Unit 3: Utilities.
Topic 1: Creating a help file - The mkmessage utility.
Topic 2: Creating and using forms.
Topic 3: Displaying forms.
Topic 4: Opening windows to display forms.
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.
Topic 2: Using clauses with the INPUT statement.
Topic 3: The INSERT statement.
Unit 7: Event handling.
Topic 1: The SQLCA record.
Topic 2: Trapping errors with the WHENEVER statement.
Topic 3: The DEFER INTERRUPT statement.
Unit 8: Query handling.
Topic 1: SELECT statement review.
Topic 2: Verifying data in I-4GL.
Unit 9: Using cursors.
Topic 1: An overview of cursors.
Topic 2: Transactions.
Topic 3: Using scroll cursors.
Unit 10: Query-by-Example.
Topic 1: The CONSTRUCT statement.
Topic 2: Preparing the query.
Unit 11: Deleting and updating rows.
Topic 1: Row locking - FOR UPDATE cursors.
Topic 2: Deleting rows.
Topic 3: Updating rows.
Unit 12: Optimizing applications.
Topic 1: Using PREPARE to optimize applications.
Topic 2: Scroll cursors and stale data.
Unit 13: Arrays.
Topic 1: Forms that use arrays.
Topic 2: The INPUT ARRAY statement.
Topic 3: INPUT ARRAY clauses.
Topic 4: Displaying arrays.
Topic 5: Pop-up windows.
Unit 14: Reports.
Topic 1: Creating a report driver.
Topic 2: The REPORT function.
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 SOA and Web services.
Topic 2: Configuring a system for Web services.
Topic 3: Using I-4GL Web service utilities.