CREATE CATALOG Statement

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. The catalog name is surrounded in double quotation marks.

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 DRIVERdriver-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 that you are configuring, refer to the section that corresponds to your data source.

Examples:

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)}