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
- 11655 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 sqlca’s maximum length?
What is the use of runstats in db2?
What is ibm db2 database?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What are the full forms of spufi and dclgen and why are they used?
What is the syntax for creating a table in the db2 database?
What is the syntax for FETCH in DB2 ?
What is a page in db2?
What is the use of value function?
can we view the access paths created by dbrm ? how ? thx
What is a collection in db2?
How to find schema of a table in db2?
How do I delete a column in db2?
Why do we use cursor?
What is the difference between spufi and qmf?
