CÓDIGO: IX150G
DURACIÓN: 32 Hours (4 días)
Precio: €1.900,00
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.
http://www.ibm.com/training/terms
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
Inserting Rows
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
Dynamic SQL: Constructing INSERT Statements
Working with the Database Server
Agenda
Day 1
Day 2
Day 3
Day 4