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 |
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
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?
What is a SELECT statement?
What is db2 purescale?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Can one database have multiple instances?
How to get the ddl of a table in db2?
What is meant by concurrency?
What is runstats db2?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
How do you retrieve the data from a nullable column?
Why select is not preferred in embedded sql programs?