Objetivo

Ao participar do Curso Informix 4GL Developing Applications, os participantes aprenderão a:

• Desenvolva aplicativos customizados usando IBM Informix 4GL
• Crie menus personalizados
• Crie formulários de entrada de dados personalizados
• Use efetivamente instruções SQL em seus aplicativos
• Incorporar rotinas de tratamento de erros em sua aplicação
• Integrar recursos de ajuda on-line em seu aplicativo
• Use transações em seu aplicativo
• Produza relatórios personalizados
• Use matrizes de tela
• Insira várias linhas usando arrays
• Execute instruções SQL dinâmicas
• Bloquear linhas do banco de dados durante atualizações
• Implante funções 4GL como serviços Web

Publico Alvo

• Este Curso Informix 4GL Developing Applications, é para Desenvolvedores de Aplicativos, Administradores de Banco de Dados e Sistemas, Líderes de Projeto e Indivíduos de Suporte Técnico.

Pre-Requisitos

• Experiência anterior em programação
• Experiência no uso de Linguagem de Consulta Estruturada (SQL)
• Experiência com UNIX ou Linux é recomendada

Materiais

Português/Inglês + Exercícios + Lab Pratico

Conteúdo Programatico

IBM Informix 4GL and the IBM Informix Toolset

1. Explain to others how IBM Informix 4GL fits into the client/server architecture of IBM Informix products
2. Tell the difference between the compiled IBM Informix 4GL C Compiler Version and IBM Informix
3. 4GL Rapid Development System

Basic Components of IBM Informix 4GL

1. Define the terms: PROGRAM, MODULE, FUNCTION, and FORM
2. Understand how these components make up an IBM Informix 4GL program

IBM Informix 4GL The Programmer's Environment

1. Navigate through the IBM Informix 4GL Programmer's Environment menu
2. Choose the appropriate menu option for a given task
3. Use the alternative command-line options to create programs

Procedural Logic

1. Use IBM Informix 4GL syntax for decision logic, including IF statements and CASE statements
2. Follow IBM Informix 4GL syntax for logic loops, including WHILE loops and FOR loops

Screen Interaction Statements

1. Describe the features of the following IBM Informix 4GL statements: ERROR, MESSAGE, DISPLAY, and PROMPT
2. Modify default display characteristics for these statements using the OPTIONS statement

The MENU Statement

1. Use the MENU statement to create an IBM Informix 4GL ring menu
2. Suggest a menu path to a user
3. Create hidden menu options
4. Hide or display specific menu options

Creating a Help File: The mkmessage Utility

1. Use the mkmessage utility to compile a customized Help file for Their application
2. Understand the menu used when Their Help file is invoked
3. Change the default Help key
4. Include a Help option in a 4GL statement

Forms in IBM Informix 4GL

1. Create a default form
2. Select a table for a form
3. Modify a default form
4. Specify attributes for a form
5. Compile a form

Displaying Forms and Windows

1. Display a form to the screen
2. Open a window on the screen
3. Use the statements associated with clearing windows
4. Use the statements needed to release the memory used by forms and windows

Data Types in IBM Informix 4GL

1. Use the different data types in IBM Informix 4GL
2. Defining Program Variables
3. Define the appropriate variables for Their program
4. Understand the scope of program variables
5. Know which data types can be used to define a variable in Their program

The Input Statement

1. Use the INPUT statement to enter information into program variables
2. Change the default options for accepting data entry from end users

Using Clauses with the INPUT Statement

1. Controlling the movement of the cursor through a form based on user input
2. Using the value entered in one field to calculate a value for another field
3. Invoking field level help through the use of special built-in functions

The Insert Statement

1. Take the values entered by a user and insert them into a database table

The SQLCA Record

1. Recognize the variables that make up the SQLCA record
2. Understand how SQLCA record can be used

Trapping Errors with the WHENEVER Statement

1. Tell the program that You will test for errors in Their IBM Informix 4GL program
2. Recover from errors in Their IBM Informix 4GL program
3. Use a compile switch to change the condition of error handling

Trapping User Entered Interrupts: The DEFER INTERRUPT Statement

1. Trap the interrupt signal during data entry

A Review of the SELECT Statement

1. Use a simple SELECT statement to return one row from the database
2. Understand the syntax for more complex SELECT statements

Verifying Data in IBM Informix 4GL

1. Make code reusable
2. Call a function within an expression
3. Verify that data being entered by an end user exists in one table before allowing it to be added to another table
4. Use the SQLCA.SQLCODE variable to see whether a row was returned by a SELECT statement

An Overview of Cursors

1. Name the three types of cursors
2. Use the appropriate cursor for a given task

Transactions in IBM Informix 4GL

1. Define a transaction
2. Use the BEGIN WORK, COMMIT WORK, and ROLLBACK WORK statements in a transaction

Using Scroll Cursors

1. Use a SCROLL cursor to retrieve rows from the database
2. Use the features of a SCROLL cursor to browse through the selected rows
3. DECLARE a cursor WITH HOLD when using transactions

Query by Example: The CONSTRUCT Statement

1. Use a CONSTRUCT statement so that end users can query-byexample

Row Locking: FOR UPDATE Cursor

1. Use a cursor declared FOR UPDATE to lock a row while it is being changed or deleted

Deleting Rows in IBM Informix 4GL

Implement the code necessary to delete a row from a table

1. Verify that a row can be deleted
2. Prompt the user for assurance of a delete

Database Updates in IBM Informix 4GL

1. Let the user access a form to change information
2. Update a row in a database

The PREPARE Statement for Optimization

1. Use a PREPARE statement to increase the speed of execution for a DELETE statement
2. Use a PREPARE statement to increase the speed of execution for an UPDATE statement
3. Use a PREPARE statement to increase the speed of execution for an INSERT statement

Scroll Cursors and Stale Data

1. Use a SCROLL cursor to SELECT a primary key
2. Use the primary key from a SCROLL cursor as an index for a nonscrolling cursor

Forms that Use Arrays

1. Create a form that uses an array
2. Define a screen array for a form that uses an array
3. Open and display a form with an array

The INPUT ARRAY Statement

1. Define a program array of records
2. Use the INPUT ARRAY statement to allow the user to enter data
3. Use the INSERT statement to transfer the program array record values into a database table

Clauses Using INPUT ARRAY

1. Control the movement of the cursor through the elements of an array based on user input
2. Use the value entered in one field to calculate a value for another field
3. Use library functions to verify information during the input

Displaying Arrays and Pop-up Windows

1. Select data from the database into a program array
2. Use the DISPLAY ARRAY statement to allow the user to scroll through the set of data
3. Populate a program array to be used in a pop-up window
4. Implement a pop-up window to display a list of valid values for a field on a form

Reports in IBM Informix 4GL: Creating a Report Driver

1. Create a report driver using the statements: START REPORT, OUTPUT TO REPORT, and FINISH REPORT
2. Create a default report using the REPORT function

The REPORT Function

1. Use the REPORT function to format the rows received by the report driver
2. Use the seven control blocks of a report to achieve the desired appearance of a report

Advanced Report Concept: Two Reports from One SELECT

1. Use one SELECT statement in two reports
2. FORMAT the same information in two different reports

Advanced Report Concept: Using Variables to Name Output Files

1. Use a variable to name an output file
2. Use information supplied by the user to create the sort key for a report

Informix 4GL Applications as Web Services

1. Define Web Service and Service-Oriented Architecture
2. Describe the process of deploying a 4GL application to a Web service
3. Configure the 4GL development environment for Web services
4. Use the 4GL tools to manage components, compile, and deploy functions as Web services