What is a DB2 catalog?
Answers were Sorted based on User's Feedback
Answer / nahid gorji
DB2 catalogs store MetaData , which means Data about Data.
Such as information about the DB2 objects created/Altered
by users or output of RUNSTATS utility which are utilized
when running SQL statement or selecting access path.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / s
DB2 stores information about all the ojects in the db2
subsystem in the catalog tables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the cascade rule and how does it relate to deletions made with a subselect?
Is schema the same as database?
Describe major components of db2?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
How is the value function used?
Request to database but database is not available so what is was abend is raised?
Why do chiropractors use drop table?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
What is with ur in db2?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
Are view updateable?