Re: Informix's short table & column descriptors

peter@prospect.anprod.csiro.au (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.....) Although 18 character names is more than enough if you start out with design using Informix, it's more than overdue for Informix to do something about this limitation for exactly the reason given here. The limitation is not lifted in any version that I know of. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org