dbTalk Databases Forums  

how to get complete column name using dbacess

comp.databases.informix comp.databases.informix


Discuss how to get complete column name using dbacess in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
dilip
 
Posts: n/a

Default how to get complete column name using dbacess - 09-29-2010 , 09:57 AM






Hi,
I am using dbaccess info column <table name>.
It outputs everything OK but when a column name is longer
say ThisisaBigColumn I see in output as ThisisaBig+
Is there any setting to output complete column name without
truncation.
thanks,
dilip

Reply With Quote
  #2  
Old   
TBP
 
Posts: n/a

Default Re: how to get complete column name using dbacess - 09-30-2010 , 10:00 AM






On Sep 29, 3:57*pm, dilip <dilip.krishnag... (AT) gmail (DOT) com> wrote:
Quote:
Hi,
I am using dbaccess info column <table name>.
It outputs everything OK but when a column name is longer
say ThisisaBigColumn I see in output as ThisisaBig+
Is there any setting to output complete column name without
truncation.
thanks,
dilip
I assume you mean "on the screen list of names"

e.g. a2345678901234567+

If the column is highlighted by moving the cursor, then the full name
will be displayed at the bottom of the screen

alternatively do a bit of sql and join the syscolumns and systables or
run dbschema etc. etc. etc.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.