DURACIÓN: 32 Hours (4 días)
If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.
In this course, you will use IBM Informix ESQL/C tools to write applications that contain embedded SQL commands and queries. You will write applications to perform queries that return single and multiple rows; insert, update, and delete rows; create and use forms to display one or more rows of data; manage cursors, and handle various types of data, including large objects.
This course replaces US Course Developing Applications Using IBM Informix ESQL/C (L1112).
This intermediate course is designed for application developers.
You should have:
Introduction to IBM Informix ESQL/C
The Demonstration Database
Embedding SQL Statements
Using CONNECT TO
Compiling an ESQL/C Program
ESQL/C Data Types
Character and String Data Types
Numeric Data Types
The SQL Communications Area
SQL Exception Testing
Using GET DIAGNOSTICS
Singleton Queries and Lookups
An Overview of Cursors
Using Scroll Cursors
Using Scroll Cursors Effectively
Using an Update Cursor
Using a Insert Cursor
Time Data Types
Simple Large Objects
Dynamic SQL: Constructing INSERT Statements
Working with the Database Server
Prior to enrolling, IBM Employees must follow their Division/Department processes to obtain approval to attend this public training class. Failure to follow Division/Department approval processes may result in the IBM Employee being personally responsible for the class charges.
GBS practitioners that use the EViTA system for requesting external training should use that same process for this course. Go to the EViTA site to start this process: http://w3.ibm.com/services/gbs/evita/BCSVTEnrl.nsf
Once you enroll in a GTP class, you will receive a confirmation letter that should show:
The current GTP list price
The 20% discounted price available to IBMers. This is the price you will be invoiced for the class.