How can tablespace be moved to another dasd volume that is allocated for that tablespace?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
Write a query to retrive partial string.
What do you need to do before you do EXPLAIN?
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?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What is page size in db2?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
What is the usage of open cursor command?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
how do u update the faltfile into db2 table ?
What is meant by AUTO COMMIT?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?