ANSI compliance for delimited identifiers
Posted in 1995
Topics: General Discussion
the Informix Corp WWW page for Informix-SE states: << quote >> Standards Compliance INFORMIX-SE meets the requirements for ANSI SQL-92 Entry Level with a few exceptions. (Notable exceptions include no support for delimited identifiers, or transactions that can be serialized.) It also supports numerous Intermediate and Full SQL-92 features, and some SQL3 features and functions. INFORMIX-SE passes a subset of the National Institute of Standards and Technology (NIST) Federal Information Processing Standard (FIPS), number 127-2 test suite for Entry Level SQL, database sizing, and the FIPS Flagger. NIST certifies conformance with ANSI and FIPS standards. The NIST SQL test suite is currently the only test suite available for validating ANSI SQL compliance. << end quote>> I'm interested in the part about delimited identifiers. Is this something that is corrected in other versions of Informix (other WWW pages don't reference delimited identifiers as a compliance problem)? If so, how do current applications deal with string literals. The 5.0 SQL reference manual says that quoted strings have a syntax that allows the characters to be surrounded by double quotes -or- single quotes. In that case I think apps will have a problem if the delimited identifier problem was corrected. Can someone help explain the situation? -- Kirk Bradley Oracle Corporation Mainframe and Integration Technologies Group