Object Name Formatting | Teradata Vantage - Format Rules for Object Naming - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantage™

There is no difference between the password rules for Japanese and non-Japanese systems. The system converts each password it receives from the session character set to UNICODE. Password format rules are enforced based on the UNICODE equivalent of the submitted password.

Setting the DBS Control NameValidationRule field imposes additional object name character restrictions. For more information, see Teradata Vantage™ - Database Utilities , B035-1102 .

In addition to the format rules that follow, password content is subject to the rules defined by setting password control options. See Working with Password Controls.

The following table summarizes object naming rules.

Parameter Description
Object name length A maximum of 127 characters when expressed in UNICODE normalization form D.
Characters allowed in object names not enclosed in quotation marks An object name not enclosed in quotation marks must be composed of an identifier-start character followed by a sequence of identifier-start or identifier extend characters, up to the maximum object name length limit.
Characters in object names not enclosed in quotation marks must also be in the session character set.
Identifier start characters must be contained in the session character set and belong to one of the following Unicode General Category classes:
  • Upper-case letters [Lu]
  • Lower-case letters [Ll]
  • Title-case letters [Lt]
  • Modifier letters [Lm]
  • Other letters ([Lo]
  • Letter numbers [Nl]
...Or be one of the following characters:
  • NUMBER SIGN (U+0023)
  • DOLLAR SIGN (U+0024)
  • LOW LINE (U+005F)
  • INVERTED EXCLAMATION MARK (U+001A)
  • OVERLINE (U+203E)
  • EURO SIGN (U+20AC)
  • KATAKANA-HIRAGANA VOICED SOUND MARK (U+309B)
  • KATAKANA-HIRAGANA SEMI-VOICED SOUND MARK (U+309B)
  • FULLWIDTH NUMBER SIGN (U+FF03)
  • FULLWIDTH DOLLAR SIGN (U+FF04)
  • FULLWIDTH LOW LINE (U+FF3F)
Identifier-extender characters must be in the session character set and belong to one of the following Unicode General Category classes:
  • Non-spacing marks [Mn]
  • Spacing combing marks [Mc]
  • Decimal numbers [Nd]
  • Connector punctuations [Pc]
  • Formatting codes [Cf]
The MIDDLE DOT character (U+00B7) is also a valid identifier-extender character.
Characters allowed only in object names that are enclosed in quotation marks A quoted string is required for object names that:
  • Have an identifier-extender character as the first character.
  • Include the white space character, SPACE (U+022)
  • Are Teradata Vantage keywords

In addition, object names that contain any character from the following classes must be enclosed in quotation marks, unless the character explicitly appears in the list of allowed characters:

  • Other, Control [Cc]
  • Other, Not Assigned [Cn]
    No characters in this category appear in UNICODE character repertoire.
  • Other, Private Use [Co]
  • Other, Surrogate [Cs]
  • Letter, Cased [LC]
  • Mark, Enclosing [Me]
  • Number, Other [No]
  • Punctuation, Dash [Pd]
  • Punctuation, Close [Pe]
  • Punctuation, Final quote [Pf] (may behave like Ps or Pe depending on usage)
  • Punctuation, Initial quote [Pi] (may behave like Ps or Pe depending on usage)
  • Punctuation, Other [Po]
  • Punctuation, Open [Ps]
  • Symbol, Currency [Sc]
  • Symbol, Modifier [Sk]
  • Symbol, Math [Sm]
  • Symbol, Other [So]
  • Separator, Line [Zl]
  • Separator, Paragraph [Zp]
  • Separator, Space [Zs]
When used to enclose an object name, the beginning and ending quotation marks must be represented as a sequence of two QUOTATION MARK characters (U+0022). Each set of two quotation marks is counted as one character when calculating the name size limit.
Disallowed characters The following characters cannot appear in an object name:
  • NULL (U+0000)
  • SUBSTITUTE character (U+001A)
  • REPLACEMENT CHARACTER (U+FFFD)
  • Compatibility ideographs (U+FA6C, U+FA6F, U+FAD0, FAD1, FAD5, FAD6, and FAD7)
The setting of the DBS Control NameValidationRule field may define additional character restrictions. See Utilities.
Other considerations These additional restrictions apply:
  • An object name consisting entirely of white spaces is not allowed.
  • A trailing white space is not considered part of an object name.
  • You can use the NameValidationRule field to restrict object name allowable characters to a subset of those normally allowed. For more information, see Teradata Vantage™ - Database Utilities , B035-1102 .