Interested to Buy Any Domain ? << Click Here >> for more details...
In which column of which DB2 catalog would you find the
length of the rows for all tables?
- 2 Answers
- 11762 Views
- I also Faced
- E-Mail Answers
Answer Posted / daphne
I assume that you mean "Column length" (Field length) for
all the fields of all the tables.
This can be found in SYSIBM.SYSCOLUMNS. The column name is
LENGTH.
If you want to find the column lengths of a particular
table then the query would be
Select NAME, LENGHT from SYSIBM.SYSCOLUMS where TBNAME =
<tablename>
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I add a column to a table in db2?
Can one database have multiple instances?
Is db2 a mainframe database?
What do you mean by cursor?
How to rename a table in DB2 ?
How do I copy a table in db2?
What is the difference between cursor stability and repeatable read isolation levels?
How many databases can be created inside an instance in db2 ?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is difference between alias and synonym in db2?
What are the contents of dclgen?
What is cursor with hold option in db2?
What is the physical storage length of time data type?
What are types of indexes?
What is catalog database in db2?
