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
- 11602 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 the max length of sqlca?
What does sqlcabc has?
Name the various locking levels available?
What is consistency token in db2?
Explain various types of locks in db2?
What is the syntax for creating a table in the db2 database?
Define buffer pool.
What are host variables in db2?
How to find primary key of a table in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is declare cursor?
How can you quickly find out the # of rows updated after an update statement?
What is difference between rollback and commit?
What is host variable in db2 cobol?
Who uses db2?
