Re: Portable object names

Posted in 1995

Catalin Badea — 17 Jul 1995 17:00:46 GMT — source: Informix-list mailing list archive (1991-1998)

rpels@aol.com (RPels) wrote: >I am currently developing under Oracle and Sybase, which allow >30-character object names. However, I'd like my object names to be >portable to other database systems. DB2/2, for example, has an 18 >character limit on column names and an 8 character limit on index names. > >Could someone tell me the maximum name lengths in INFORMIX? Thanks. Just about every object size is 18 characters (tables, columns, indexes, etc...) With SE the database name is O/S dependent (mostly 8/10 chars). Catalin. -- =========================================================================== Catalin Badea _/_/_/ _/_/_/ _/_/_/ _/_/_/ _/ _/ _/_/_/ _/ _/ _/ _/ _/_/ _/ Senior Technical Architect _/ _/_/ _/ _/_/_/ _/ _/_/_/ _/ _/ _/ _/ _/ _/ Tecsys Inc. _/ _/_/_/ _/_/_/ _/_/_/ _/ _/_/_/ ====== cat@tecsys.com =========== include system "disclaimer.4gh" ====== ====== Home Page at http://www.virtualmarketplace.com/it/TECSYSE ========