Hitachi

Hitachi Advanced Database Messages


KFAA31562-E

There is an error in the specification method in the ALTER SERVER statement. (reason = aa....aa) (M+J+O)

The specification method of the ALTER SERVER statement is invalid. <SQLSTATE:42I7A>

aa....aa: Invalid cause
  • the value for the option cannot be omitted

    The value for the foreign server option (access key string, etc.) cannot be omitted.

  • an option that is not defined by a CREATE SERVER statement cannot be changed by an ALTER SERVER statement

    A foreign server option that is not defined by a CREATE SERVER statement cannot be changed by an ALTER SERVER statement.

  • the option is already defined

    The specified foreign server option is already defined.

  • the endpoint string does not start with 'http://' or 'https://'

    The endpoint string does not start with http:// or https://.

  • only one of either the access key or the secret key cannot be added

    Only one of either the access key or the secret key cannot be added.

  • only one of either the access key or the secret key cannot be deleted

    Only one of either the access key or the secret key cannot be deleted.

  • a value was specified for an option for which values cannot be specified

    A value cannot be specified for the specified foreign server option.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Correct the SQL statement.