[Library] [View Topics Framed] [Contents] [Revised Topics] [Previous Topic] [Next Topic] [Search] [Search Results][Previous Topic Match][Next Topic Match] [Notes] [List Notes] [Print] [Download] [Download PDF] [Handheld Disconnected][Handheld Connected][Help]
2.1.6.169 -457
 





   -457    A FUNCTION OR DISTINCT TYPE CANNOT BE CALLED name  SINCE IT IS
          RESERVED FOR SYSTEM USE
Explanation: The user-defined function or distinct type cannot be created or referenced because the name selected is reserved for use by the system.

A number of names used as keywords are reserved for system use. These names may not be used as user-defined functions or distinct-type-names, even if they are delimited identifiers. These names are: 


     =        <         >         >=        <=
     ¬=        ¬>        ¬>
     ALL      AND       ANY       BETWEEN   DISTINCT
     EXCEPT   EXISTS    FALSE     FOR       FROM
     IN       IS        LIKE      MATCH     NOT
     NULL     ONLY      OR        OVERLAPS  SIMILAR
     SOME     TABLE     TRUE      TYPE      UNIQUE
     UNKNOWN

| The names of built-in data types cannot be used as the name of a distinct
| type (for example, CHAR).

System Action: The statement is not executed.

Programmer Response: Select a name for the function or distinct type that is not reserved for system use.

SQLSTATE: 42939


[Previous Topic] [Next Topic] © Copyright IBM Corp. 1982, 2001

IBM Library Server® Copyright 1989, 2003 IBM Corporation. All rights reserved.

Return to library: [ z/OS | z/OS.e | OS/390 | TPF | VM | VSE | IBM Hardware | S/390 Redbooks ]
Glossary: [ IBM terminology ]
Publications: [ How to order publications | Subscribe to publication updates ]
Readers: [ Download IBM Library Reader | Download Adobe® Acrobat® Reader® ]
Contacts: [ Contact z/OS | Contact OS/390 ]

Adobe, the Adobe logo, Acrobat, the Acrobat logo, and Acrobat Reader are registered trademarks of Adobe Systems incorporated.