ALTER DATA SERVICE Statement

Enables you to change the name of a data service. You can also change common data service attributes such as version, catalog, and domain, and other data service specific options.

ALTER [DATA] SERVICE data-service RENAME TO newname

ALTER [DATA] SERVICE data-service

   [ CATALOG [NAME] catalog-name ]

   [ DOMAIN [NAME] domain-name ]

  [ REGISTER [( catalog-name1 [,catalog-name2 …]) | ALL]

   [alter-data-service-options ]

data-service

Specifies the data service name.

newname

Specifies the new data service name.

catalog-name

Specifies the domain name.

domain-name

Specifies the domain name.

REGISTER [(catalog-name1 [, catalog-name2...]) | ALL]

Catalog registration specification. (Optional) Specify a list of catalogs to register or ALL keyword to register all catalogs visible to the connection.

register-options ::=
         [ UID principal ]
         [ PWD password ]
         [ VALIDATE [N[O]|F[ALSE]|OFF|0|Y[ES]|T[RUE]|ON|1]]

UID principal

Data Service user principal name.

PWD password

Data service user password.

VALIDATE [N[O] | F[ALSE] | OFF | 0 | Y[ES] | T[RUE] | ON | 1]

Specifies whether the connection and the catalog names are to be validated.

VALIDATE defaults to TRUE if not specified or if no Boolean value keyword is specified and either UID or PWD is specified. If VALIDATE is true and neither UID, nor PWD are specified, then a data service user principal name and password (personal credentials) are extracted on behalf of the caller from the domain associated with the data service. The statement returns TKTS_ERROR if no such credentials exist.

If an explicit catalog list is specified and VALIDATE is TRUE, then each catalog must exist or the statement returns TKTS_ERROR. If VALIDATE is TRUE but no catalogs are specified (including REGISTER ALL), then only the connection itself is validated since the catalog list is either empty or supplied by the connection.

alter-data-service-options

Specifies the list of data service options to alter.

   alter-data-service-options::=

      "{" OPTIONS ["(") alter-data-service-option

                 [{ "," alter-data-service-option } ...] 
                                                            [")"]"}"

alter-data-service-option

Specifies the data service option to alter.

     alter-data-service-option ::=

        [ alter-operation ]data-service-option

data-service-option

Specifies the data service option.

     data-service-option::= 
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. Some data services such as ORACLE accept connections from the SAS Federation Server Driver for ODBC as well. For these data services, two CONOPTS lists can be configured, one per driver to accept connections for the two drivers. The SAS Federation Server Driver for ODBC accepts a CONOPTS driver connection string option. To configure this option and suboptions within it, the configuration format is CONOPTS( driver ODBC, CONOPTS( ... ) ). The inner CONOPTS option, within the parenthesis, is a list-valued driver connection string, while the outer CONOPTS option groups arbitrary driver connection string options configured for the service.

conopts-configuration-list::=
CONOPTS "(" [DRIVER driver-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. The DATA_SERVICE and CATALOG connection string options should not be specified here since they are implied by the data service and its configured catalogs.

Both connection options and advanced options are valid to use as driver connection string options. For more information about which connection options and advanced options are supported for each data service, see the SAS Federation Server Driver Referencefor your driver.

Autoindex ON|OFF

This option is transient and valid for the SQL_LOG data service only. Specifies whether to create indexes (ON) or to drop indexes (OFF) for the EVENTS table used for SQL Logging. The default is ON.

Examples

ALTER DATA SERVICE ORACLE3 {OPTIONS conopts(Driver odbc,
 ODBC_DSN tktsora)}

ALTER DATA SERVICE ORACLE3 RENAME TO ORACLE3_RENAME

ALTER DATA SERVICE ORACLE3_RENAME {OPTIONS DROP conopts(driver odbc) }

alter service service1 catalog newcatalog

alter service ORACLE4 DOMAIN ORA8

ALTER DATA SERVICE ORACLE3_RENAME {OPTIONS SET conopts(driver odbc,
 ODBC_DSN tktsora3) }

ALTER SERVICE SAPSERV {OPTIONS conopts(xset batch 1, xset destgroup SAS)};