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
- 11515 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
What is package in db2 mainframe?
What is with ur in db2?
Can we update view in db2?
What is a dbrm in db2?
What are concurrency issues?
What are db2 objects?
What is a trigger in the db2 database?
What is the difference between spufi and qmf?
Explain various types of locks in db2?
What is null indicator in db2?
Define predicate?
What is the use of reorg in db2?
Define buffer pool.
How connect db2 database to datastage?
What is ibm db2 connect?
