Where besides the DB2 catalog is database object
information stored by DB2?
Answer / s
Datbase object information is stored in a internal format
in DBD, Database Descriptors.
| Is This Answer Correct ? | 2 Yes | 0 No |
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What's The Percentage Free Space ?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What information can you find in SYSIBM.SYSLINKS table?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
wht displays the number of times a query modified ?
Can we use select * statement in cobol program without giving field names ???
If I have a view which is a join of two or more tables, can this view be updateable?
What information is used as input to the bind process?
How do you eliminate duplicate values in db2?
Can we delete records from view?
What is the command used by TSO users to invoke DB2?