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?
2 5025I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
3 6565
Is the primary key a clustered index?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Is ibm db2 free?
What is load replace in db2?
Which are the db2 tools to protect integrity of the database?
What is data manager?
How is deadlock resolved?
How to find schema of a table in db2?
What is the difference between using bind () and rebind () methods of naming class?
What do you mean by cursor?
What is an instance in db2?
What is the difference between cursor and select statement?
Mention the downsides of page level lock.
What is the use of with ur in db2?