ALTER CATALOG enables
you to change the name of a catalog. You can also change the native
catalog name and the advanced options that are driver–specific.
For information about which advanced options are supported for each
data service, see the driver reference chapter for your data source.
ALTER CATALOG "catalog" RENAME TO "newcatalogname"
[ NATIVE NAME "native-name" ]
[ alter-catalog-options ]
“catalog”
Specifies the name
of the catalog.
“newcatalogname”
Specifies the new catalog
name.
“native-name”
Specifies the name
of the native catalog.
alter-catalog-options
Specifies the options
to alter the catalog. This option only applies to the BASE data service.
The syntax for alter-catalog-options is the same as the syntax for
alter-generic-options. All create-catalog-options are also supported.
ALTER CATALOG "catalog3_BASE" RENAME TO "catalog3_BASE_RENAME"
ALTER CATALOG "Catalog3" NATIVE NAME "TKTEST3_RENAME"
ALTER CATALOG "catalog1_BASE" {OPTIONS add CONOPTS(DRIVER BASE, ACCESS READONLY)}ALTER CATALOG "catalog1_BASE" {OPTIONS set (CONOPTS(DRIVER BASE, ACCESS READONLY))}ALTER CATALOG "catalog1_BASE" {OPTIONS xset CONOPTS(DRIVER BASE, COMPRESS YES)}ALTER CATALOG "catalog1_BASE" {OPTIONS drop CONOPTS(DRIVER BASE)}