Display Label length limitation
Red Valsen asked about the length limit for display labels in a SELECT on IDS 7.31.UC4. Jonathan Leffler said 18 characters like other identifiers, possibly 128 from 9.20. Paul Watson thought it was still 18 in 9.20.UC2, but Leffler tested a very long label on 9.20.UC2 (Solaris 7) and it worked fine. Limit for 9.20 was left to that test.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Is there a length limitation for the so-called "display labels" in an Informix SQL query? For example: select client_nm name_of_client from client order by client_nm; What is the limitation of the display label after the column name, "name_of_client" in this case? Is it documented anywhere? We're using IDS 7.31.UC4/x86 (don't ask). TIA
Red Valsen wrote: > > Is there a length limitation for the so-called "display labels" in an > Informix SQL query? For example: > > select client_nm name_of_client from client order by client_nm; > > What is the limitation of the display label after the column name, > "name_of_client" in this case? Is it documented anywhere? > > We're using IDS 7.31.UC4/x86 (don't ask). 18 characters, same as other names (column names, table names, etc). The answer should be 128 if you upgrade to 9.20...I haven't verified that. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"
I think it's still 18, or at least that what it appears to be in 9.20.UC2 Jonathan Leffler wrote: > > Red Valsen wrote: > > > > Is there a length limitation for the so-called "display labels" in an > > Informix SQL query? For example: > > > > select client_nm name_of_client from client order by client_nm; > > > > What is the limitation of the display label after the column name, > > "name_of_client" in this case? Is it documented anywhere? > > > > We're using IDS 7.31.UC4/x86 (don't ask). > > 18 characters, same as other names (column names, table names, etc). > > The answer should be 128 if you upgrade to 9.20...I haven't verified > that. > > -- > Yours, > Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> > Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN > "I don't suffer from insanity; I enjoy every minute of it!" -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #
Paul Watson wrote:
>
> I think it's still 18, or at least that what it appears to be in
> 9.20.UC2
Not on my Solaris 7 machine running IDS.2000 version 9.20.UC2:
select tabidimpossibly_long_display_label_to_test_the_obtuseness_of_r_and_d from
systables where tabid = 1;
This worked fine for me (but I was using SQLCMD, of course). What did
you get?
> Jonathan Leffler wrote:
> > Red Valsen wrote:
> > > Is there a length limitation for the so-called "display labels" in an
> > > Informix SQL query? For example:
> > >
> > > select client_nm name_of_client from client order by client_nm;
> > >
> > > What is the limitation of the display label after the column name,
> > > "name_of_client" in this case? Is it documented anywhere?
> > >
> > > We're using IDS 7.31.UC4/x86 (don't ask).
> >
> > 18 characters, same as other names (column names, table names, etc).
> >
> > The answer should be 128 if you upgrade to 9.20...I haven't verified
> > that.
--
Yours,
Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h>
Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN
"I don't suffer from insanity; I enjoy every minute of it!"