-20074   THE OBJECT object-name CANNOT BE CREATED BECAUSE THE FIRST THREE CHARACTERS ARE RESERVED FOR SYSTEM OBJECTS

Explanation

An attempt was made to create an object, but the name that was specified cannot be used because it begins with reserved characters.

object-name
The name of the object.

The following restrictions apply to object names:

Reserved prefix "SYS"
With a few exceptions, the string "SYS" is not permitted in the first three characters of an object name.

This message is also issued for a GRANT statement in response to an attempt to grant the CREATEIN, ALTERIN or DROPIN privileges on a schema with the "SYS" prefix. The same restrictions apply in this case.

Prefix "DSN"
A database name cannot consist of the string "DSN" followed by five digits.
Role names
Role names cannot start with any of the following strings:
  • ACCESSCTRL
  • DATAACCESS
  • DBADM
  • DBCTRL
  • DBMAINT
  • NONE
  • NULL
  • PACKADM
  • PUBLIC
  • SECADM
  • SQLADM
  • SYS

This condition is similar to the condition reported in precompiler message DSNH794I.

System action

The statement cannot be processed.

Programmer response

Select a name that does not start with a reserved string.

SQLSTATE

42939