how to see the full column name in informix window
Please see the attachment of informix window. See the column name "daridrya_survey_f+". i want to see the full name of this column name but i don't know how to see? Please give the solution. can i see the full column name on same window and same location? Actual column name is "daridrya_survey_finyear".
Hi,
attachments are not put in the list. I assume, you have tried to see the
columns of a table
in dbaccess info menu.
Dbaccess has an internal restriction, which cuts off the full name. It is not
parametrized,
as AFAIK.
Use dbschema to see the complete column names, if they are too long for
dbaccess to display.
Marcus
----- Ursprüngliche Mail -----
Von: "SANDIP SHINDE" <sandipvshinde1983@gmail.com>
An: ids@iiug.org
Gesendet: Montag, 7. Januar 2013 13:34:40
Betreff: how to see the full column name in informix window [29198]
Please see the attachment of informix window. See the column name
"daridrya_survey_f+". i want to see the full name of this column name but i
don't know how to see?
Please give the solution. can i see the full column name on same window and
same location?
Actual column name is "daridrya_survey_finyear".
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Sorry, but attachements do not get posted on the forum. You will have to
paste it directly into your post if you want us to see it. What "Informix
window" are you talking about? Do you mean the table name listing in
dbaccess's menus? That was designed back when all table names were limited
to 18 characters and cannot be changed.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Mon, Jan 7, 2013 at 7:34 AM, SANDIP SHINDE
<sandipvshinde1983@gmail.com>wrote:
> Please see the attachment of informix window. See the column name
> "daridrya_survey_f+". i want to see the full name of this column name but i
> don't know how to see?
>
> Please give the solution. can i see the full column name on same window and
> same location?
>
> Actual column name is "daridrya_survey_finyear".
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f46d0447f05e89cc8c04d2b2d139
Another alterative, if you just want a table list by database get my
utils2_ak package. In there is the utility listdb7. You can run:
listdb7 -d <databasename> -t
that will list all of the tables in the selected database. If you add the
-D option it will tell you about each table and every index on those tables
(size, location, lock mode, etc.).
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Mon, Jan 7, 2013 at 7:39 AM, Marcus Haarmann
<marcus.haarmann@midoco.de>wrote:
> Hi,
>
> attachments are not put in the list. I assume, you have tried to see the
> columns of a table
> in dbaccess info menu.
> Dbaccess has an internal restriction, which cuts off the full name. It is
> not
> parametrized,
> as AFAIK.
> Use dbschema to see the complete column names, if they are too long for
> dbaccess to display.
>
> Marcus
>
> ----- Ursprüngliche Mail -----
>
> Von: "SANDIP SHINDE" <sandipvshinde1983@gmail.com>
> An: ids@iiug.org
> Gesendet: Montag, 7. Januar 2013 13:34:40
> Betreff: how to see the full column name in informix window [29198]
>
> Please see the attachment of informix window. See the column name
> "daridrya_survey_f+". i want to see the full name of this column name but i
> don't know how to see?
>
> Please give the solution. can i see the full column name on same window and
> same location?
>
> Actual column name is "daridrya_survey_finyear".
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f646e73b4930604d2b2dd79
you could also use OAT to see col names
dbaccess shows
classification_te+ lvarchar(4096) no
Oat shows
classification_text UDTVAR lvarchar