|
|
|
 |
IN112Developing Applications Using Informix ESQL/C
Thшы course is devoted to questions of creation of applications with resources of operation with databases. You learn how to create applications in which necessary data structures or SQL operators are defined in execution time of the program. Fulfilling practical exercises, you can gain real experience in writing the various programs providing as simple access to databases, and with check of errors, a data conversion, operation with cursors and usage of dynamically set SQL.
- To include more complex SQL operators in programs on С for addition, extracts and changes of the data in databases Informix
- To set structure of the cursor for a manipulation a recordset
- To work with all types SQL of the data
- To set and fulfil dynamically defined SQL
Contents of course
- the Browse of products Informix
- Acquaintance with INFORMIX-ESQL/C
- Embedding of SQL operators in the program on ESQL/C
- Compilation of the program on INFORMIX-ESQL/C
- Usage of simple variables in INFORMIX-ESQL/C
- the Insert of records in the program on INFORMIX-ESQL/C
- Operation with SQLCA (SQL Communication Area) in the program on ESQL/C
- Check of exclusive situations in the program on ESQL/C
- Single inquiries in the program on ESQL/C
- the Browse of cursors of various types
- SCROLL-cursors
- the Effective utilization of SCROLL-cursors
- Usage of UPDATE-cursors
- Usage of INSERT-cursors
- Usage of instruction CONNECT TO
- Usage of instruction GET DIAGNOSTICS
- Usage of data type DECIMAL
- Usage of data type VARCHAR
- Usage of data types DATETIME and INTERVAL
- Usage of data types BYTE and TEXT
- Dynamic SQL-inquiries in the program on ESQL/C
- One more example of usage of dynamic SQL-inquiries
- Operation with a database server
- A Application. Features INFORMIX-ESQL/C for Windows
- B Application. Creation многонитиевой programs on ESQL/C
- Appendix C. An example of usage of dynamic SQL-inquiries
Preliminary preparation
Course IN613 " the Structured query language - SQL " or equivalent knowledge, and also knowledge of the editor vi and Unix operating system on a user level (necessary skills can be gained, having heard course S215 " Introduction in SCO Unix "), experience of programming in language С.
Education coast on cource - USD 390
Cource duration (days) - 3
|
|
