Re: informix info? (Max identifier length)

At 04:55 PM 11-08-98 -0400, Ariel wrote: >--Informix Question-- > >In the latest version of Informix what are the maximum values for: >- Name length of a column (charters)? >- Name length of a table (charters)? >- Max. number of columns per table? > >I am doing some research on DB's and this information is very hard to get >from the vendors site. You can find the answer from the Informix site via the following path: http://www.informix.com choose "Product Documentation" choose "Informix Dynamic Server 7.3" choose "Guide to SQL: Syntax" (assuming Adobe plug-in) choose "Identifiers" Under "Usage" it says: "An identifier can be up to 18 bytes, inclusive." Under the coming 9.2 product this limit will be extended to 132 bytes. HTH, _____________________________________________________________ Clem Akins (aka clem@informix.com) Menlo Park x5937 Customer Course Development Informix Software, Inc Last seen: Riding the waves of a 5.3 California earthquake!