The CREATE CATALOG statement
enables you to create a catalog using the syntax below.
CREATE CATALOG "catalog" UNDER data-service
[ NATIVE NAME native-name ]
[ create-catalog-options ]
“catalog”
Specifies the catalog
name.
data-service
Specifies the data
service name under which the catalog is to be created.
native-name
Specifies the native
catalog name. Specified when the native catalog name is not unique
within the server. The native name should be used to resolve catalog
name collisions between multiple data services that support catalogs.
Client SQL always references the catalog via the logical catalog
name (catalog) regardless of whether a native name is specified. Specifying
a native name that matches the logical name does nothing.
create-catalog-options
Specifies the options
to create a catalog. This option only applies to the BASE data service.
create-catalog-options ::=
create-catalog-options::=
conopts-configuration-list
conopts-configuration-list
If DRIVER driver-name
is omitted, the default driver for the data service is assumed. Associated
options within the CONOPTS list are used for connections using the
appropriate driver. The multiple driver syntax is not supported
conopts-configuration-list::=
CONOPTS "(" [DRIVERdriver-name] ["," driver-connection-string-option ...] ")" ...
driver-name
Specifies the driver
name.
driver-connection-string-option
Specifies the connection
options that correspond to the driver which is specified in DRIVER driver-name.
Advanced options are
valid to use as driver connection string options; connection options
are invalid. For more information about which advanced options are
supported for each data service, see the data service reference chapter
for your driver. For information specific to the data service you
are configuring, go to the section that corresponds to your data service.
CREATE CATALOG "catalog1_BASE" UNDER BASE
CREATE CATALOG "TKTEST" UNDER SQLServer1
CREATE CATALOG "Catalog1" UNDER SQLServer1 NATIVE NAME "TKTEST"
CREATE CATALOG "c1" UNDER BASE {OPTIONS conopts (COMPRESS YES)}