Re: Informix's short table & column descriptors

Peter Wiley wrote: > > I've just finished converting 94 tables from an Oracle database schema to > Informix. > > Please please, can we have more than 18 characters for table & column > names? It's a real PITA having to do this by hand - even with a good text > editor. Especially when you have heaps of PK-FK relations. > > This is for SE 5.07 on Solaris, BTW. If the limit is higher on Online or a > later release of SE, I'd appreciate knowing it. Might have more Orcale > databases to convert :-) (Or Progress ones, he mutters darkly.....) This is Informix complying with an ANSI standard that most do not. :-) This applies across ALL Informix products. However, there is talk of this ANSI standard being revised, probably to bring it into line with most databases out there. What Informix will do then, we will have to wait and see. Cheers, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+