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

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--"--create dbaccessdemo--"---->
                     '-task--'                                 

>--+---------------------------------------------------------------------------------------+-->
   '-,--"--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");

Copyright© 2019 HCL Technologies Limited