Command-Line Syntax

Home | Previous Page | Next Page Getting Started with DB-Access > Creating and Working with the Demonstration Databases >

Command-Line Syntax

The illustrations in this section show the syntax of the initialization scripts. For assistance in reading the diagrams, see Syntax Diagrams in the introduction to this manual.

To create stores_demo

>>-dbaccessdemo--+-------+--+--------+-------------------------->
                 '- -log-'  '-dbname-'
 
>--+-------------------------+---------------------------------><
   '- -dbspace--dbspace_name-'

Extended Parallel Server

To create sales_demo

>>-dbaccessdemo-- -dw------------------------------------------><

End of Extended Parallel Server

Dynamic Server

To create superstores_demo

>>-dbaccessdemo_ud--+-------+--+--------+----------------------->
                    '- -log-'  '-dbname-'
 
>--+-------------------------+---------------------------------><
   '- -dbspace--dbspace_name-'

End of Dynamic Server

-dw: creates the sales_demo database.
-log: requests transaction logging for the demonstration database.
dbname: substitutes for the default database name. For object-name guidelines, see the IBM Informix: Guide to SQL Syntax.
-dbspace: requests a particular dbspace location for the demonstration database.
dbspace_name: houses the demonstration database. If you do not specify a dbspace name, by default, the data for the database is put in the root dbspace. To create a dbspace, use the onspaces utility as described in your IBM Informix: Administrator's Guide.

Examples

The following command creates a database named stores_demo:
```
dbaccessdemo
```
The following example creates an instance of the stores_demo database named demo_db:
```
dbaccessdemo demo_db 
```
The following command initializes the stores_demo database and also initiates log transactions:
```
dbaccessdemo -log 
```
The following command creates an instance of the stores_demo database named demo_db in dbspace_2:
```
dbaccessdemo demo_db -dbspace dbspace_2
```