Setting Up Your System › Setting Up Database Access › Setting Up SQL Access to Non-SQL Databases › Creating SQL Synonyms

Creating SQL Synonyms

When a FOR LANGUAGE SQL synonym is defined for a non-SQL record, CA IDMS uses the element synonyms for all SQL access. SQL synonyms are used only for element names.

Defining SQL synonyms for non-SQL records is sometimes the only way to overcome column name limitations within SQL. Some non-SQL element names do not make satisfactory SQL column names, even after hyphens are changed to underscores. For example, if a non-SQL element name begins with a numeric character, you must still use double quotes around the element name. For example, to access 123-ORD-NUM, you would code "123_ORD_NUM" in an SQL statement.