Supply error messages and a user guide
- The SQL statement syntax in the HCL Informix Guide to SQL: Syntax
- The HCL Informix Guide to SQL: Tutorial and the IBM Informix Database Design and Implementation Guide
These documents include examples of HCL Informix® SQL statements and expected results, which the SQL user consults.
The user of your access method will expect the SQL statements and keywords to behave as documented in the database server documentation. If the access method causes an SQL statement to behave differently, you must provide access-method documentation and messages to alert the user to these differences.
In the access-method user guide, list all SQL statements, keywords, and options that raise an exception if a user attempts to execute them. Describe any features that the access method supports in addition to the standard SQL statements and keywords.
Create callback functions to respond to database server exceptions, as Handle the unexpected describes. Raise access-method exceptions for conditions that the database server cannot detect. Use the following sections as a checklist of items for which you supply user-guide information, callback functions, and messages.