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.
|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:
Or be one of the following characters:
Identifier-extender characters must be in the session character set and belong to one of the following Unicode General Category classes:
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:
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:
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:
The setting of the DBS Control NameValidationRule field may define additional character restrictions. See Utilities.
|Other considerations||These additional restrictions apply: