How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
3 6969If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
2 5257
What is an instance database?
Is schema the same as database?
What is the usage of open cursor command?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What are types of indexes?
What is the result of open cursor statement?
What are the prerogatives?
What is the clustering index in the db2 database?
What is the use of runstats in db2?
What is db2 bind process?
What kind of database is db2?
What is the difference between plan and package in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the maximum number of columns in a db2 table?
What is rct?