When using ODBC with CMS, you must keep the following in mind:

Dictionary names: Clients can access CMS Dictionary names. You must map the synonym to the report from the client.

Permissions: Applications that access Informix externally, such as database access scripts, might not work if the table permission script tries to access a table to which permission is denied.

Field display: The time and date data you receive from the database might not be formatted. Generally, times can be shown in seconds or in 24-hour clock format. You need to review data for formatting when you import it into your software application. The data returned from your SQL queries will be formatted in the manner described in your database interface specifications. See your software’s documentation for further information on formatting data.

Switch features and capabilities: Some switch features and capabilities have an impact on CMS open database items.

For more information on these features and capabilities, see the appropriate database items and calculations document for your CMS release.