Informix SQL statement detailed explanation

1.CREATE database database_name [with LOG in ' pathname '] creates the databases.

database_name: Database name.

"Pathname": Transaction processing log file.

Create a Database_name.dbs directory, access permissions set by Grant, no log file can not be used

A transaction statement such as BEGIN work (which can be changed with the start database statement).

You can select a log file for the current database.

For example: Select Dirpath form systables where tabtype = "L";

Example: Create Databse Customerdb with log in "/usr/john/log/customer.log";

2.DATABASE databse-name [EXCLUSIVE] Select the database.

database_name: Database name.

EXCLUSIVE: Exclusive state.

Access the database in the current directory and in the directory specified in DBPath, and do not use this statement during processing in transactions.

Example: Dtabase Customerdb;

3.CLOSE DATABASE

Closes the current database.

database_name: Database name.

After this statement, only the following statements are valid:

CREATE database; database; DROP databse; Rollforward database;

You must use this statement before you delete the database.

Example: Close database;