DB2 SQL-Error: -20074

Short Description: THE OBJECT CANNOT BE CREATED BECAUSE THE FIRST THREE CHARACTERS ARE RESERVED FOR SYSTEM OBJECTS

In general, SYS is a reserved prefix for names. The only exceptions to this rule include the following conditions: v SYSADM and SYSTOOLS are valid schema names. v SYSPROC is a valid schema name for stored procedures. v SYSIBM is a valid schema name for a stored procedure when the current application process has the SYSADM or SYSCTRL privilege. v SYSTOOLS is a valid schema name when the current application process has the SYSADM or SYSCTRL privilege. This message is also issued if an attempt is made to grant the CREATEIN, ALTERIN or DROPIN privileges on a schema with the SYS prefix. The same exceptions apply to the grant. This condition is similar to the condition reported in precompiler message DSNH794I. System action: The statement is not executed. Programmer response: Select a name that does not start with a reserved prefix.

 <-  BACK TO INDEX