Topic
  • 1 reply
  • Latest Post - ‏2012-11-22T13:01:17Z by SystemAdmin
Atul.Singh
Atul.Singh
10 Posts

Pinned topic Not able to see thw whole column in db2

‏2012-11-17T12:44:20Z |
Hi Techies..
I am executing a list table command on XMETA DB and got the result like this...
*bold*db2 list tables for schema XMETA | head*bold*
Table/View Schema Type Creation time

---------------
--------------------------
ACLENTRIES_2 XMETA T 2012-10-21-18.53.56.936002
ACLS_2 XMETA T 2012-10-21-18.53.56.906002
AGENT_XMETAGEN_AGENT5874305 XMETA T 2012-10-21-18.58.46.997003
AGENT_XMETAGEN_HANDLERTYPE5874> XMETA T 2012-10-21-18.58.47.287005
AGENT_XMETAGEN_HANDLERTYPEAGEN> XMETA T 2012-10-21-18.58.47.477001
AGENT_XMETAGEN_HANDLERTYPEAGEN> XMETA T 2012-10-21-18.58.47.367005
AGENT_XMETAGEN_HANDLERTYPEAGEN> XMETA T 2012-10-21-18.58.47.257001
here as u can see here, I am not able see the whole table name.
Is there another way by which I can increase the column size ?

Thanks
Atul Singh
http://victimizeit.blogspot.in
Updated on 2012-11-22T13:01:17Z at 2012-11-22T13:01:17Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    17917 Posts

    Re: Not able to see thw whole column in db2

    ‏2012-11-22T13:01:17Z  
    Hello Atul,

    Just query the catalog view SYSCAT.TABLES :

    db2 "select TABNAME, TABSCHEMA, TYPE, CREATE_TIME from SYSCAT.TABLES where TABSCHEMA='XMETA'"

    Regards

    Yves-Antoine Emmanuelli