Teradata 16.20 reserved words

Database
Enthusiast

Teradata 16.20 reserved words

Hi ,

 

I would like to know the query to find the reserved words for Teradata 16.20 .

 

Currently i m using Teradata 14.10. I used the below query to find the reserved words for Teradata 15.10 . Wil it be the same for Teradata 16.20 ? Or we have to use a different query ?

 

 

select
 CASE r.category
   WHEN 'N' THEN 'NONRESERVED'
   WHEN 'R' THEN 'RESERVED'
   WHEN 'F' THEN 'FUTURE'
   ELSE ''
 END ||
 CASE r.ANSI_restricted
   WHEN 'T' THEN '/TD'
   ELSE '/ANSI'
 END
 (Title 'STATUS') (format 'X(18)'),
 d.databasenamei,t.tvmname,tv.fieldname,
 trim(d.databasenamei)||'.'||trim(t.tvmname)||'.'||trim(fieldname) (Title 'Conflict//Field/Index//Name') (format 'X(384)')
from dbc.tvfields tv,dbc.tvm t,dbc.dbase d,SYSLIB.SQLRestrictedWords r
        where
        (t.tvmid = tv.tableid)
        and (r.category in ('N'))
        and (tv.fieldname = r.restricted_word)
        and (tv.databaseid = d.databaseid)
        and not ((t.tablekind = 'N') and (tv.fieldname = 'UNIQUE'))
        and d.databasename not in ('default','public','all','dbc','DBCMNGR',
        'sysibm','system','Q','SQLDBA','SYSUDTLIB','TD_SYSFNLIB','SYSLIB',
        'SYSSPATIAL','SYS_CALENDAR','TDStats','SYSBAR','SQLJ','TDQCD',
        'TD_SYSXML','CRASHDUMPS','LockLogShredder','SYSADMIN')
order by 2,3,4;

 

1 REPLY
Senior Apprentice

Re: Teradata 16.20 reserved words

Hi,

That query runs on a 16.20 system.

You'll probably want to add 'TDMaps' to your list of excluded database names.

The following is a list of databasenames owned by DBC on a 16.20 system:

External_AP
SYSSPATIAL
SYSLIB
SYSJDBC
sysdba
SYSBAR
LockLogShredder
SysAdmin
PUBLIC
SQLJ
SystemFe
dbcmngr
DBC
davec_db
tdwm
Default
TD_SERVER_DB
TD_SYSFNLIB
console
All
viewpoint
TD_SYSGPL
TD_SYSXML
Crashdumps
TDStats
TDPUSER
Sys_Calendar
TDMaps
SYSUIF
TDQCD
SYSUDTLIB

 

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com