Administration DDL

Description

Administration DDL is a set of commands used for administration of SAS Federation Server. Most administration DDL is performed by an administrator (defined as a user who has the ADMINISTER privilege on SAS Federation Server), but some commands, such as CREATE CACHE, require specific privileges which can be assigned to users and groups.

GENERIC Options

Generic options is a set of comma separated name or name-value pairs, that can be used within an OPTIONS list. When a DDL statement contains an options list, you can define additional configurations using GENERIC options.

generic-options ::=
      "{" OPTIONS ["("] generic-option-list [")"] "}"

generic-option-list ::=
      generic-option[ {"," generic-option} ... ]

generic-option ::=
      option-name [ {option-value | option-list} ]

           
option-list ::=
      "("
option-value [ {"," option-value} ... ] ")"

option-value ::=
     quoted-identifier

Use ALTER GENERIC options to include a modifier for a specific option. Modifiers such as ADD, SET, XSET or DROP can be used when altering system objects, for example a SCHEMA. Here is an example:

ALTER SCHEMA "catalog1_BASE"."schema3_BASE" {OPTIONS add conopts (LOCKTABLE SHARE)}

alter-generic-options ::=
"{" OPTIONS ["("] alter-generic-option-list [")"] "}"

alter-generic-option-list ::=
alter-generic-option [ {"," alter-generic-option} ... ]

alter-generic-option ::=
[alter-operation ]option-name
[ {option-value |option-list } ]

alter-operation ::= ADD | SET | XSET | DROP

alter-operation

Indicates the required action for the specified options. If a value is omitted for alter-operation, ADD is the default modifier. The possible values are:

ADD

Adds the specified option.

SET

Changes an option that already exists.

XSET

Sets the option if it has already been added. Otherwise, adds the option if it does not already exist.

DROP

Drops the specified option.

Last updated: March 6, 2018