Regular and Delimited Identifiers
Identifiers in OpenSQL statements specify names for the following objects:
• User
• Column
• Correlation name
• Cursor
• Database procedure
• Database procedure parameter
• Index
• Prepared query
• Schema
• Table
• View
Specify these names using regular (unquoted) identifiers or delimited (double‑quoted) identifiers. For example:
• Table name in a select statement specified using a regular identifier:
select * from employees
• Table name in a select statement specified using a delimited identifier:
select * from "my table"
Delimited identifiers allow special characters to be embedded in object names. OpenSQL restricts the use of special characters in regular identifiers.