Archives of the TeradataForum

Message Posted: Thu, 12 Apr 2012 @ 11:58:18 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Sughesh,

You can find whether the keyword is reserved or not by using the following command below. But I don't know whether this query will work in 13.0 or not.

     BTEQ -- Enter your SQL request or BTEQ command:
     show view SYSLIB.SQLRestrictedWords;

     show view SYSLIB.SQLRestrictedWords;

      *** Text of DDL statement returned.
      *** Total elapsed time was 1 second.

     ---------------------------------------------------------------------------
     REPLACE VIEW SYSLIB.SQLRestrictedWords AS SELECT restricted_word, category,
     ANSI_restricted FROM TABLE (SQLRestrictedWords_TBF()) as t1 WHERE release_introduced <= '14.00' AND
           (release_dropped IS NULL OR release_dropped > '14.00');


      BTEQ -- Enter your SQL request or BTEQ command:
     sel * from SYSLIB.SQLRestrictedWords;

     sel * from SYSLIB.SQLRestrictedWords;

      *** Query completed. 821 rows found. 3 columns returned.
      *** Total elapsed time was 6 seconds.

     restricted_word                 category  ANSI_restricted
     ------------------------------  --------  ---------------
     ABORT                           R         T
     ABORTSESSION                    R         T
     ABS                             R         R
     ACCESS_LOCK                     R         T
     ACCOUNT                         R         T
     ACOS                            R         T
     ACOSH                           R         T
     ADD                             R         N
     ADD_MONTHS                      R         T

But For your reference ,below are the list of Reserved and Non-Reserved Words keywords in 13.0 and 13.10 which are not in 12.

13.00 Reserved Words

     CONNECT
     CTCONTROL
     CURRENT_ROLE
     CURRENT_USER
     EXPAND EXPANDING
     GET
     RESIGNAL
     SIGNAL
     UNTIL_CHANGED
     VARIANT_TYPE
     XMLPLAN

13.00 Non-Reserved Words

     APPLNAME
     CLASS_ORIGIN
     COMMAND_FUNCTION
     COMMAND_FUNCTION_CODE
     CONDITION
     CONDITION_IDENTIFIER
     CONDITION_NUMBER
     CREATOR
     DIAGNOSTICS
     DOWN
     EXCEPTION
     GLOP
     LDIFF+
     MEETS+
     MEMBER
     MESSAGE_LENGTH
     MESSAGE_TEXT
     MORE
     NODDLTEXT
     NUMBER
     OLD_NEW_TABLE
     OWNER
     P_INTERSECT
     P_NORMALIZE
     PERIOD
     PRECEDES
     PRIORAN
     RDIFF
     RESET
     RETURNED_SQLSTATE
     ROW_COUNT
     RULES
     RULESET
     SUBCLASS_ORIGIN
     SUCCEEDS
     THROUGH
     TRANSACTION_ACTIVE
     XML

13.10 Reserved Words

     NONTEMPORAL
     NORMALIZE
     TRANSACTIONTIME
     UNTIL_CLOSED
     VALIDTIME
     METADATA

13.10 Non-Reserved Words

     ALLOCATE
     ANCHOR
     DECOMPRESS
     FRIDAY
     INLINE
     MERGEBLOCKRATIO
     MONDAY
     MONTH_BEGIN
     MONTH_END
     NONSEQUENCED
     SATURDAY
     SEQUENCED SUNDAY
     TEMPORAL_DATE
     TEMPORAL_TIMESTAMP
     THURSDAY
     TRUST_ONLY
     TUESDAY
     WEDNESDAY
     WORKLOAD

Hope it will be helpful to you

Thanks,

Murali

	<Prev	Next>		<<First	<Prev	Next>	Last>>