Re: Informix's short table & column descriptors

Of course the only reason why such a restriction would exist in the ANSI standard is that some very large company insists on such a limitation so that their database can be compliant without a major rewrite. E.g. 1. 18 character table/column name limitation in DB2. 2. Externally linked names must be unique in the first 8 characters in the ANSI C standard because mainframe C compilers typically can't handle any more. 3. ANSI compliant databases must close all open cursors upon commit because several popular databases cannot preserve open cursors across one. 4. Apparently, ODBC drivers are also supposed to start up in AUTOCOMMIT mode because many ODBC data sources have no transaction control. - Mark Butler Peter Wiley wrote: Please please, can we have more than 18 characters for table & column names? Mark D. Stock wrote: This is Informix complying with an ANSI standard that most do not. :-) -- Mark D. Butler ( butlerm @ xmission.com ) Software Engineer Epic Systems 662 North 100 East Farmington UT 84025 (801)-451-4583