16.10 - NameValidationRule - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Determines whether additional rules are used by Teradata Database to validate object names.

Field Group

General

Valid Settings

Setting Description
0 No additional name validation is performed beyond basic validation rules.
1 Name validation rules used in pre-14.10 releases.
2 Name validation using a minimal character set:

'A' - 'Z', 'a' - 'z', '0' - '9', '#', '$', and '_'

62 Name validation using the UTF16 client character set.
63 Name validation using the UTF8 client character set.
64 Name validation using the EBCDIC client character set.
65 through 126 Name validation using a user-defined character set.
127 Name validation using the ASCII client character set.

Default

0

Changes Take Effect

After the next Teradata Database restart for new objects. Objects created prior to changing this setting are unaffected by the change.

Related Topics

For more information on... See...
Basic object naming rules SQL Fundamentals.
System language support mode System Initializer (sysinit) chapter in Support Utilities.
User-defined character sets International Character Set Support.