-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.