dbaccess long identifiers
Posted in 2013
Topics: Stored Procedures & SPL, Server Administration
Hi all
We are looking for a way to configure dbaccess to not cut tablesnames
after 18 characters. It's not even possible to see tablenames shorter
than 18 characters if the owner is displayed before the tablename.
That's always the case if you are not owner of the table.
BTW, isql doesn't cut after 18 characters.
TIA
Reinhard
There is no way to set the width of the tablename list. However, a week or
two ago John Miller posted a way to change the display from three columns
to two columns which expands the width of each column. Search the forum
history.
Art
Art S. Kagel, Principal Consultant
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 Wed, Oct 23, 2013 at 8:34 AM, Habichtsberg, Reinhard <
RHabichtsberg@arz-emmendingen.de> wrote:
> Hi all
>
> We are looking for a way to configure dbaccess to not cut tablesnames
> after 18 characters. It's not even possible to see tablenames shorter
> than 18 characters if the owner is displayed before the tablename.
> That's always the case if you are not owner of the table.
>
> BTW, isql doesn't cut after 18 characters.
>
> TIA
> Reinhard
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e0158cb9266f79f04e96883f9
There are two ways to see the full table name.
1. The full table name is display at the bottom of the screen for the
highlighted tables.
2. the full table name can also be displayed when hitting the + (the
plus sign.)
dbaccess has to deal with table names that can be 128 characters.
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 10/23/2013 05:34:09 AM:
> From: "Habichtsberg, Reinhard" <RHabichtsberg@arz-emmendingen.de>
> To: ids@iiug.org,
> Date: 10/23/2013 05:36 AM
> Subject: dbaccess long identifiers [31784]
> Sent by: ids-bounces@iiug.org
>
> Hi all
>
> We are looking for a way to configure dbaccess to not cut tablesnames
> after 18 characters. It's not even possible to see tablenames shorter
> than 18 characters if the owner is displayed before the tablename.
> That's always the case if you are not owner of the table.
>
> BTW, isql doesn't cut after 18 characters.
>
> TIA
> Reinhard
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>