In which column of which DB2 catalog would you find the length of the rows for all tables?
In the RECLENGTH column of SYSIBM.SYSTABLES
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Given an N x M two dimensional array of integers where all rows and columns are sorted in ascending order, write a function that can determine if a certain value exists in the array. 10.11.08
A: The obvious brute force solution would involve checking each item in the array to see if matches the desired value. This does not take advantage of the fact...What is the difference between CHAR and VARCHAR data types? 06.11.08
CHAR is a fixed length data type. CHAR(n) will take n characters of storage even if you enter less than n characters to that column. For example, "Hello!" w...What is implied Join. Where do we find it ? 03.11.08
Join between two Tables. Join Object defines The Relationship Between a Bc and atable.Join allows Bc to get Column from table rather then basetable. I...How can we create picklist? 26.09.08
Picklist: It allows users to populate the fields by selecting values from a list rather than typing them in a field. Two types are Static & Dynamic, Crea...How will you estimate the space required by non-clustered tables? 23.05.08
Calculate the total block header size Calculate the available data space per block Calculate the combined column length of the average row Calculate the tota...In how many ways we can retrieve table records count? How to find the count of records in a dataset ? 14.04.08
foreach(DataTable thisTable in myDataSet.Tables){ // For each row, print the values of each column. foreach(DataRow myRow in thisTable.Rows){...Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database ? 10.04.08
The catalog tables to use are the SYSIBM.SYSTABLES and the SYSIBM.SYSCOLUMNS....What DB2 Catalog column tell you when an index needs table reorganized ? 09.04.08
The FAROFFPOS column of the SYSIBM.SYSINDEXPART table....Give some example of statistics collected during RUNSTATS ? 18.03.08
Number of rows in the table, Percent of rows in clustering sequence, Number of distinct values of indexed column, Number of rows moved to a nearby/fairway pag...What is a DB2 catalog ? 12.03.08
The DB2 catalog is a set of tables that contain information about all of the DB2 objects(tables, views, plans etc.)....