1.4.3 Table name specification rules

(1) Specification rules that apply if a table name contains any lowercase letter

If the table name to be specified for a command argument contains any lowercase letter, use either of the following specification formats:

• Individually enclose the schema name and the table identifier between pairs of a backslash and a double quotation mark (\").

  Example: If the table name is ADBUser01.Table01:

  \"ADBUser01\".\"Table01\"

• Individually enclose the schema name and the table identifier between double quotation marks ("), and then enclose the entire table name between single quotation marks (').

  Example: If the table name is ADBUser01.Table01:

  '"ADBUser01"."Table01"'

If these specification rules are not followed, all characters in the schema name and table identifier are interpreted as uppercase letters. For example, if ADBUser01.Table01 is specified, it is assumed that ADBUSER01.TABLE01 is specified.

To Page Top

(2) Specification rules that apply if a table name contains a backslash (\)

If the table name to be specified for a command argument contains a backslash (\), use either of the following specification formats:

1. Enclose the entire table name between single quotation marks (').

2. Specify the escape character (\) immediately before the backslash.

If the table name contains lowercase letters, use specification format 1.

Example 1: If the table name is ADBUser01.Table\01:

'"ADBUser01"."Table\01"'

Example 2: If the table name is ADBUSER01.TABLE\01:

'ADBUSER01.TABLE\01' or ADBUSER01.TABLE\\01

To Page Top