In this course, you will use IBM Informix ESQL/C tools to write applications that contain embedded SQL commands and queries. Students 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.

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

• Include SQL statements in a C program to add, retrieve, and alter data in an Informix database
• Set up a cursor structure for manipulating a set of rows
• Work with all SQL data types
• Set up and execute dynamically defined SQL statements
• Write effective, efficient SQL-based applications in C

This intermediate course is for application developers.

You should complete:

• IBM Informix Structured Query Language or equivalent knowledge
• ANSI C programming or C programming experience

• Unit 1: Introduction to IBM Informix ESQL/C
• Exercise 1
• Unit 2: The Demonstration Database
• Exercise 2
• Unit 3: Embedding SQL Statements
• Exercise 3
• Unit 4: Using CONNECT TO
• Exercise 4
• Unit 5: Compiling an ESQL/C Program
• Exercise 5
• Unit 6: ESQL/C Data Types
• Unit 7: Character and String Data Types
• Exercise 6
• Unit 8: Numeric Data Types
• Exercise 7
• Unit 9: Inserting Rows
• Exercise 8
• Unit 10: The SQL Communications Area
• Exercise 9
• Unit 11: SQL Exception Testing
• Exercise 10
• Unit 12: Using GET DIAGNOSTICS
• Exercise 11
• Unit 13: Singleton Queries and Lookups
• Exercise 12
• Unit 14: An Overview of Cursors
• Exercise 13
• Unit 15: Using Scroll Cursors
• Exercise 14
• Unit 16: Using Scroll Cursors Effectively
• Unit 17: Using an Update Cursor
• Exercise 15
• Unit 18: Using an Insert Cursor
• Unit 19: Time Data Types
• Exercise 16
• Unit 20: Simple Large Objects
• Exercise 17
• Unit 21: Dynamic SQL
• Exercise 18
• Unit 22: Dynamic SQL: Constructing INSERT Statements
• Unit 23: Working with the Database Server
• Exercise 19