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
- 11511 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vat
'RECLENGTH' column of SYSIBM.SYSTABLES would have the
record/row length of the table.
It's format: 8 + n + l where
8 accounts for 6 header bytes and 2 ID map entry bytes
n = 0 if there is no edit proc otherwise 10
l = Sum of max. col lengths (Add 1 byte for Null indicator
for nullable columns, 2 bytes for Varchar columns, 4 bytes
for LOB column)
and, RECLENGTH is 0 for auxilary tables, views and aliases
| Is This Answer Correct ? | 1 Yes | 0 No |
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Can we able to find all the Table names under a Particular Plan?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
Give some example of statistics collected during RUNSTATS?
What's the maximum number of characters that a tablename can have?
How do you run JCL in cobol program
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
What is the picture clause of null indicator variable?
What is the use of dclgen in db2?
COBOL 
