create dbaccessdemo argument: Create the demonstration database (SQL administration API)
Use the create dbaccessdemo argument with the admin() or task() function to create the stores_demo demonstration database.
Syntax
EXECUTE FUNCTION
{
admin
| task
}
("create dbaccessdemo
"
[ ,"database_name
"
[ ,"
dbspace"
[ ,"-log
" ]
[ ,"-nots
" ]
]
]
);
| Element | Purpose | Key considerations |
|---|---|---|
| database_name | The name of the database to create. | Default database name is stores_demo. |
| dbspace | The name of the dbspace in which to create the database. | Default dbspace is the root dbspace. |
Usage
Run this function to create the stores_demo database.
Use the -log option to enable transaction logging for the demonstration database.
Use the -nots option to prevent the creation of the tables with time series data in the demonstration database.
Examples
The following command creates the stores_demo database in the root dbspace:
EXECUTE FUNCTION task("create dbaccessdemo");The following command creates the demonstration database named demo2, in a dbspace named dbs1:
EXECUTE FUNCTION task("create dbaccessdemo","demo2","dbs1");The following command creates the stores_demo database in a dbspace named dbs1 with transaction logging:
EXECUTE FUNCTION task("create dbaccessdemo","stores_demo","dbs1","-log");