Developing Applications Using Informix 4GL

Corso

A Milano

Prezzo da consultare

Chiama il centro

Hai bisogno di un coach per la formazione?

Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.

Descrizione

  • Tipologia

    Corso

  • Luogo

    Milano

  • Inizio

    Scegli data

Prerequisiti
You should have:
Previous programming experience
Experience in using Structured Query Language (SQL)
Experience using UNIX or Linux is recommended
Target del corso
This is an intermediate course for application developers, database and system administrators, project leaders, and technical support individuals.

Sedi e date

Luogo

Inizio del corso

Milano
Visualizza mappa
viale Piero e Alberto Pirelli 6, 20126

Inizio del corso

Scegli dataIscrizioni aperte

Domande e risposte

Aggiungi la tua domanda

I nostri consulenti e altri utenti potranno risponderti

Chi vuoi che ti risponda?

Inserisci i tuoi dati per ricevere una risposta

Pubblicheremo solo il tuo nome e la domanda

Opinioni

Materie

  • Web master
  • Pop-up
  • Windows
  • Amministrazione di sistemi

Programma

dettagliati del corso
IBM Informix 4GL and the IBM Informix Toolset
Explain to others how IBM Informix 4GL fits into the client/server architecture of IBM Informix products
Tell the difference between the compiled IBM Informix 4GL C Compiler Version and IBM Informix 4GL Rapid Development System.
Basic Components of IBM Informix 4GL
Define the terms: PROGRAM, MODULE, FUNCTION, and FORM
Understand how these components make up an IBM Informix 4GL program
IBM Informix 4GL The Programmer´s Environment
Navigate through the IBM Informix 4GL Programmer´s Environment menu
Choose the appropriate menu option for a given task
Use the alternative command-line options to create programs
Procedural Logic
Use IBM Informix 4GL syntax for decision logic, including IF statements and CASE statements
Follow IBM Informix 4GL syntax for logic loops, including WHILE loops and FOR loops
Screen Interaction Statements
Describe the features of the following IBM Informix 4GL statements: ERROR, MESSAGE, DISPLAY, and PROMPT
Modify default display characteristics for these statements using the OPTIONS statement
The MENU Statement
Use the MENU statement to create an IBM Informix 4GL ring menu
Suggest a menu path to a user
Create hidden menu options
Hide or display specific menu options
Creating a Help File: The mkmessage Utility
Use the mkmessage utility to compile a customized Help file for your application
Understand the menu used when your Help file is invoked
Change the default Help key
Include a Help option in a 4GL statement
Forms in IBM Informix 4GL
Create a default form
Select a table for a form
Modify a default form
Specify attributes for a form
Compile a form
Displaying Forms and Windows
Display a form to the screen
Open a window on the screen
Use the statements associated with clearing windows
Use the statements needed to release the memory used by forms and windows
Data Types in IBM Informix 4GL
Use the different data types in IBM Informix 4GL
Defining Program Variables
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
The Input Statement
Use the INPUT statement to enter information into program variables
Change the default options for accepting data entry from end users
Using Clauses with the INPUT Statement
Controlling the movement of the cursor through a form based on user input
Using the value entered in one field to calculate a value for another field
Invoking field level help through the use of special built-in functions
The Insert Statement
Take the values entered by a user and insert them into a database table
The SQLCA Record
Recognize the variables that make up the SQLCA record
Understand how SQLCA record can be used
Trapping Errors with the WHENEVER Statement
Tell the program that you will test for errors in your IBM Informix 4GL program
Recover from errors in your IBM Informix 4GL program
Use a compile switch to change the condition of error handling
Trapping User Entered Interrupts: The DEFER INTERRUPT Statement
Trap the interrupt signal during data entry
A Review of the SELECT Statement
Use a simple SELECT statement to return one row from the database
Understand the syntax for more complex SELECT statements
Verifying Data in IBM Informix 4GL
Make code reusable
Call a function within an expression
Verify that data being entered by an end user exists in one table before allowing it to be added to another table
Use the SQLCA.SQLCODE variable to see whether a row was returned by a SELECT statement
An Overview of Cursors
Name the three types of cursors
Use the appropriate cursor for a given task
Transactions in IBM Informix 4GL
Define a transaction
Use the BEGIN WORK, COMMIT WORK, and ROLLBACK WORK statements in a transaction
Using Scroll Cursors
Use a SCROLL cursor to retrieve rows from the database
Use the features of a SCROLL cursor to browse through the selected rows
DECLARE a cursor WITH HOLD when using transactions
Query by Example: The CONSTRUCT Statement
Use a CONSTRUCT statement so that end users can query-byexample
Row Locking: FOR UPDATE Cursor
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
Verify that a row can be deleted
Prompt the user for assurance of a delete
Database Updates in IBM Informix 4GL
Let the user access a form to change information
Update a row in a database
The PREPARE Statement for Optimization
Use a PREPARE statement to increase the speed of execution for a DELETE statement
Use a PREPARE statement to increase the speed of execution for an UPDATE statement
Use a PREPARE statement to increase the speed of execution for an INSERT statement
Scroll Cursors and Stale Data
Use a SCROLL cursor to SELECT a primary key
Use the primary key from a SCROLL cursor as an index for a nonscrolling cursor
Forms that Use Arrays
Create a form that uses an array
Define a screen array for a form that uses an array
Open and display a form with an array
The INPUT ARRAY Statement
Define a program array of records
Use the INPUT ARRAY statement to allow the user to enter data
Use the INSERT statement to transfer the program array record values into a database table
Clauses Using INPUT ARRAY
Control the movement of the cursor through the elements of an array based on user input
Use the value entered in one field to calculate a value for another field
Use library functions to verify information during the input
Displaying Arrays and Pop-up Windows
Select data from the database into a program array
Use the DISPLAY ARRAY statement to allow the user to scroll through the set of data
Populate a program array to be used in a pop-up window
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
Create a report driver using the statements: START REPORT, OUTPUT TO REPORT, and FINISH REPORT
Create a default report using the REPORT function
The REPORT Function
Use the REPORT function to format the rows received by the report driver
Use the seven control blocks of a report to achieve the desired appearance of a report
Advanced Report Concept: Two Reports from One SELECT
Use one SELECT statement in two reports
FORMAT the same information in two different reports
Advanced Report Concept: Using Variables to Name Output Files
Use a variable to name an output file
Use information supplied by the user to create the sort key for a report
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

Chiama il centro

Hai bisogno di un coach per la formazione?

Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.

Developing Applications Using Informix 4GL

Prezzo da consultare