Many of the fields in the Control Center allow two types of SQL identifiers: ordinary identifiers and delimited identifiers. Many replication values, such as table names, require that the case of the value match the name of the object. The online help and the tasks in this book specify which fields accept both ordinary or delimited identifiers.
An ordinary identifier:
| Note: | If you type a lowercase letter as part of an ordinary identifier in a field, the lowercase letter is stored as an uppercase letter. |
A delimited identifier:
| Note: | Leading spaces are stored as part of a delimited identifier, but trailing spaces are ignored. |
To name a target table WKLYSAL, you can type: WKLYSAL or wklysal or Wklysal in the Target table field. The lowercase letters are changed to uppercase and the table name is stored as WKLYSAL. If you want the name of the table to be Wkly Sal, type: "Wkly Sal" in the Target table field. The quotation marks are recognized as the delimiters of the identifier, and the table name is stored as Wkly Sal.
If you want the name of a column to be "Nickname", type: """Nickname""" in the Column name field. The outermost quotation marks are recognized as the delimiters of the identifier and each pair of consecutive quotation marks represents one quotation mark. The column name is stored as "Nickname".