Creating a Database

Home | Previous Page | Next Page The Database Option >

Creating a Database

To create a new database instead of selecting an existing one, select the Create option from the DATABASE menu. The CREATE DATABASE screen appears, as Figure 27 shows.

Figure 27. The CREATE DATABASE Screen

CREATE DATABASE >>   
Enter the name you want to assign to the new database, then press Return.

------------------------------------------- Press CTRL-W for Help --------

Enter a name for the database that you want to create and press RETURN.

Note:

You can assign any name to your database, as long as you follow the syntax guidelines described in the IBM Informix: Guide to SQL Syntax.

To create a database on another database server, specify the server name with the database name. Follow the syntax guidelines described in the IBM Informix: Guide to SQL Syntax.

After you name the new database, the CREATE DATABASE menu appears as Figure 28 shows.

Figure 28. The CREATE DATABASE Menu

CREATE DATABASE :   Dbspace   Log Exit
Select a dbspace for storing the database's data.

------------------------------------------- Press CTRL-W for Help -------

You can specify that a database be stored in a nonroot dbspace or create a database with or without buffered transaction logging or create an ANSI-compliant database.