In which column of which DB2 catalog would you find the
length of the rows for all tables?
- 2 Answers
- 11038 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 bind plan?
What is the use of value function?
How can the duplicate values be eliminated from db2 select?
Comment whether the cursor is closed during commit or not.
Can we update view in db2?
How connect db2 database to datastage?
What is coalesce in db2?
What is copy pending and check pending in db2?
Explain in detail about buffer manager and its functionalities?
What is the maximum size of varchar data type in db2?
What is multi row fetch in db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Why do we use cursor?
What is an instance database?
List down the types of triggers in the db2 database?
