SQL/MP Messages Manual

SQLCI Utility Processor Messages (9000 to 9999)
HP NonStop SQL/MP Messages Manual—427720-006
11-79
SQL 9908
Cause. The VALUE attribute of the field listed in the message contained a LOCALE
specification. SQL has not been enhanced to recognize and process LOCALE
specifications.
Effect. SQL ignores the VALUE attribute. The field is treated as if it did not have a
VALUE attribute. If the command does not need the value from the VALUE attribute,
the command executes normally. If the command needs the value from the VALUE
attribute, the command will fail with another error message.
This warning appears only for the first field in the record for which the VALUE was
ignored. SQL also ignores the VALUE attribute for any fields later in the record that
contain LOCALE specifications, but those fields are not mentioned in a warning
message.
Recovery. Remove the LOCALE specification and rebuild the dictionary. Check all
following fields for LOCALE specifications, too.
SQL 9910
Cause. You requested a MODIFY DICTIONARY operation from a user ID other than
the super ID, and the CHECKONLY option was not specified.
Effect. The command fails. No modification is done.
Recovery. Reissue the command from the super ID, or reissue the command and
specify the CHECKONLY option.
SQL 9911
Cause. A user-defined TMF transaction was in effect when the MODIFY
DICTIONARY command was entered.
Effect. The command fails. No modification is done.
Recovery. Consider entering a COMMIT WORK or ROLLBACK WORK command to
end your transaction, and reissue the MODIFY DICTIONARY command.
9908 The VALUE attribute for field value-1 was ignored
because it contained a LOCALE specification.
9910 Security violation. The super ID is required for the
MODIFY DICTIONARY command unless CHECKONLY is specified.
9911 The MODIFY DICTIONARY command is not allowed in a user
transaction.