|
|
|
 |
IN335Using Stored Procedures and Triggers
The course is intended for developers of applications and system administrators using INFORMIX-SE, INFORMIX-OnLine or INFORMIX-OnLine Dynamic Server. Questions of usage and introduction of triggers and stored procedures in your databases Informix are studied. Speaks as to create and fulfil stored procedures with the help of operators of language of stored procedures. Creation and usage of triggers for call of stored procedures
After learning course you is considered can
- To explain advantage of usage of stored procedures
- To use operators of language of stored procedures
- To create and fulfil stored procedures
- To transfer stored procedures parameters and to accept returned values
- To recognize the situations suitable to application of triggers
- To create triggers
- To use triggers for an autocall of stored procedures
the Contents of course
- Stored procedures. The fact-finding chapter
- Creation and execution of stored procedures
- Operators of language of stored procedures
- Exception handling
- Triggers
- Operating conditions for stored procedures and triggers
- A Application. An example of a program code of stored procedures
Preliminary preparation
IN611 " Designing of relational databases " IN613 "Structured query language", knowledge of the editor vi and Unix operating system on a user level (necessary skills can be gained, having heard course 3-day's S215).
Education coast on cource - USD 260
Cource duration (days) - 2
|
|
