-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