Honey-Apple: Informix Database Learning Collection [Add]

First, Infomix use Memo
Directory structure:
1. Start and stop orders;
2. Modify the database encoding;
3. View the ports that Informix occupies;
4. Use the dbaccess command to import and build table information from a file;
5. Give a user DBA authority for a library;
6. Configuration of the. Bash_profile for users who connect to the Informix library
7. Informix Export Table Data
8. Informix Modifies table field properties
9. Decimal type for Informix
Ii. some important concepts in Informix
1. Chunks
2. Dbspaces
3. blobspaces
4. Sbspaces
5. Reading and caching data
6. Physical logs and logical logs
7. Checkpoint (checkpoints) and recovery (Recovery)
Iii. types of data and examples in Informix
1. Built-in data types
2. Complex object type (complex data type)
3. Custom object Type (User Defined datatypes)
Iv. Common SQL statements for Informix
1. Create a database
2. Create a normal data table
3. Create a temporary data table
4. Create a PRIMARY KEY constraint
5. Create referential constraints
6, check the constraints
7. Create a View
8. Query statements
9. Insert statement
10. UPDATE statements
11. Delete statements
V. Triggers for Informix
1. Introduction
2. Important Concepts
3. Trigger instance
4, the advantages of the trigger
Vi. stored procedures for Infomix
1. Introduction
2. Important Concepts
3. Grammar
4. Process Control in SPL
5. Exception Handling
6. Perform SPL functions or stored procedures
7. Delete SPL functions or stored procedures
VII. transaction, concurrency control, lock mechanism, isolation level for Informix
1. Business
2. Concurrency control
3. Lock mechanism
4. Isolation levels for transactions and sessions
5. Set the transaction/session lock mode

Http://www.blogjava.net/amigoxie/archive/2010/11/20/338548.html

Honey-Apple: Informix Database Learning Collection [Add]