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.104.22.1686002
ACLS_2 XMETA T 2012-10-21-22.214.171.1246002
AGENT_XMETAGEN_AGENT5874305 XMETA T 2012-10-21-126.96.36.1997003
AGENT_XMETAGEN_HANDLERTYPE5874> XMETA T 2012-10-21-188.8.131.527005
AGENT_XMETAGEN_HANDLERTYPEAGEN> XMETA T 2012-10-21-184.108.40.2067001
AGENT_XMETAGEN_HANDLERTYPEAGEN> XMETA T 2012-10-21-220.127.116.117005
AGENT_XMETAGEN_HANDLERTYPEAGEN> XMETA T 2012-10-21-18.104.22.1687001
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 ?
This topic has been locked.
1 reply Latest Post - 2012-11-22T13:01:17Z by SystemAdmin
Pinned topic Not able to see thw whole column in db2
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-22T13:01:17Z at 2012-11-22T13:01:17Z by SystemAdmin
SystemAdmin 110000D4XK17917 PostsACCEPTED ANSWER
Re: Not able to see thw whole column in db22012-11-22T13:01:17Z in response to Atul.SinghHello Atul,
Just query the catalog view SYSCAT.TABLES :
db2 "select TABNAME, TABSCHEMA, TYPE, CREATE_TIME from SYSCAT.TABLES where TABSCHEMA='XMETA'"