Use quoted identifiers to specify column names - Connect_CDC - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

You can use the Connect CDC grammar “quoted identifier” feature to reference column (or table) names that contain blanks or special identifiers. In Connect CDC’s grammar, the double quote character (") is used to delimit one of these special identifiers. In some databases a quoted identifier is referred to as a “delimited identifier.”

For example, for a column name defined as 'My test case column!'; the column name contains all characters except the single quotes. When you have an SQL statement or Connect CDC expression referencing this column, this type of column needs to be specified as a quoted identifier. For example:

"My test case column!"

The use of double quotes ensures that the embedded spaces and special characters do not cause a parsing error in the grammar of the database or Connect CDC. Using double quotes enables Connect CDC (and any SQL database) to unambiguously parse this identifier as a column name.

Quoted identifiers can be used for table names, schema names and database names, if this latter type of identifier is supported in the database as it is in MS SQL Server. In addition, a valid column name (one that does not contain special characters that cannot be parsed) can also be specified as a quoted identifier. For example, a column named 'INVOICE_NUMBER'; could also be specified as a quoted identifier such as: "INVOICE_NUMBER".