Which is the maximum number of characters for table name ?
Stefano Teodorani asked the maximum table name length. Reinhard Habichtsberg said 18 characters up to 7.31 or 9.14 and 32 from IDS.2000. Jonathan Leffler corrected this: IDS.2000 and Foundation.2000 allow 128-character table names and 32-character user names; earlier versions allow 18 and 8. Chetan Anand warned isql and 4GL 7.20 could not handle names over 18 characters, though DB-Access 9.20 could.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Which is the maximum number of characters for table name in Informix database ? Please send your answer to s.teodorani@esasoftware.com
Version <= 7.31 or 9.14: 18 since IDS.2000: 32 (posted and mailed) Stefano Teodorani <s.teodorani@esasoftware.com> schrieb in im Newsbeitrag: 81ipt6$o20$1@fe1.cs.interbusiness.it... > Which is the maximum number of characters for table name in Informix > database ? > > Please send your answer to s.teodorani@esasoftware.com > > > >
Reinhard Habichtsberg wrote: > Version <= 7.31 or 9.14: 18 > since IDS.2000: 32 Hmm; not quite. IDS.2000 and Foundation.2000 allow table names up to 128 characters, and user names up to 32 characters. All earlier versions use the limits 18 and 8 respectively. > Stefano Teodorani <s.teodorani@esasoftware.com> schrieb in im > Newsbeitrag: 81ipt6$o20$1@fe1.cs.interbusiness.it... > > Which is the maximum number of characters for table name in Informix > > > database ? Posted only. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN #include <disclaimer.h>
Is the database on Unix or NT?? What version? I believe it's 18 char's on NT until 9.x -brian On Fri, 26 Nov 1999 20:40:16 -0800, Jonathan Leffler <jleffler@earthlink.net> wrote: >Reinhard Habichtsberg wrote: > >> Version <= 7.31 or 9.14: 18 >> since IDS.2000: 32 > >Hmm; not quite. > >IDS.2000 and Foundation.2000 allow table names up to 128 characters, and >user names up to 32 characters. > >All earlier versions use the limits 18 and 8 respectively. > >> Stefano Teodorani <s.teodorani@esasoftware.com> schrieb in im >> Newsbeitrag: 81ipt6$o20$1@fe1.cs.interbusiness.it... >> > Which is the maximum number of characters for table name in Informix >> >> > database ? > >Posted only. > >-- >Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) >Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN >#include <disclaimer.h> > > > Senior Systems Engineer(A little of this, A little of that... mostly INFX) VF Corp
Hi: Be careful, I recently encountered problems with isql/4gl when accessing table names more than 18 characters. INFORMIX-SQL Version 7.20.HE1 Software Serial Number ACN#J288413 DONOT HANDLE DB-Access Version 9.20.HC1 Software Serial Number ACN#J288408 OK INFORMIX-4GL Version 7.20.HE1 Software Serial Number ACN#J288410 DONOT HANDLE Jonathan has clarified that there will be some release of isql / 4gl to handle long names. Rgds FosterB wrote: > Is the database on Unix or NT?? What version? > > I believe it's 18 char's on NT until 9.x > > -brian > > On Fri, 26 Nov 1999 20:40:16 -0800, Jonathan Leffler > <jleffler@earthlink.net> wrote: > > >Reinhard Habichtsberg wrote: > > > >> Version <= 7.31 or 9.14: 18 > >> since IDS.2000: 32 > > > >Hmm; not quite. > > > >IDS.2000 and Foundation.2000 allow table names up to 128 characters, and > >user names up to 32 characters. > > > >All earlier versions use the limits 18 and 8 respectively. > > > >> Stefano Teodorani <s.teodorani@esasoftware.com> schrieb in im > >> Newsbeitrag: 81ipt6$o20$1@fe1.cs.interbusiness.it... > >> > Which is the maximum number of characters for table name in Informix > >> > >> > database ? > > > >Posted only. > > > >-- > >Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) > >Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN > >#include <disclaimer.h> > > > > > > > > Senior Systems Engineer(A little of this, > A little of that... > mostly INFX) > > VF Corp