Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
1 7059How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
2 9098In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
1 10312
Describe major components of db2?
Explain about mirror activator disk mirroring?
What is the difference between bind and rebind in db2?
Are view updateable?
Why do chiropractors use drop table?
What is schema in db2?
Can one database have multiple instances?
Mention data types used in db2 ?
How to access db2 tables in mainframe?
What is isolation level in db2?
What is a system catalog table in db2?
Mention the different locking levels that are available in db2.
How to get the ddl of a table in db2?
What is the use of reorg in db2?
How to fetch the last row from the table in SQL (db2)?