Oninit cdi / Archive
Talk to an expert →

Which is the maximum number of characters for table name ?

Posted in 1999

Topics: General Discussion

Stefano Teodorani — — source: Informix-list mailing list archive (1991-1998)

Which is the maximum number of characters for table name in Informix database ? Please send your answer to s.teodorani@esasoftware.com

↪ replying to Stefano Teodorani
Reinhard Habichtsberg — — source: Informix-list mailing list archive (1991-1998)

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 > > > >

↪ replying to Reinhard Habichtsberg
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)

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>

↪ replying to Jonathan Leffler
FosterB — — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to FosterB
Chetan Anand — — source: Informix-list mailing list archive (1991-1998)

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

Related threads