CODEWITHSUNDEEP
command-linedb2
Clodoaldo Neto
Clodoaldo Neto

Reputation: 125244

Truncated names in DB2 tables list

In the Windows command line when I ask for the table names in a certain schema the names are truncated:

db2 => list tables for schema SCH

Tabela/Exibição                 Esquema                         Tipo  Hora da cria
------------------------------- --------------- ----- --------------------------
TRUNCATED_TABLE_NAME_TRUNCATED> SCH             T     2017-01-29-11.11.11.111111

How to show the whole name without truncating or wrapping?

Upvotes: 0

Views: 478

Answers (2)

Stavr00
Stavr00

Reputation: 3314

Increase the column with in the DB2 CLP with

CHANGE MAXCOLUMNWIDTH TO 80

Upvotes: 0

data_henrik
data_henrik

Reputation: 17118

Use SQL:

select tabname,tabschema from syscat.tables where tabschema='SCH'

See the catalog views for details on more options.

Upvotes: 1

Related Questions