How do I add a column 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?
Explain what are the various isolation levels possible?
What is package in cobol db2?
Can we use select * statement in cobol program without giving field names ???
How many databases can be created inside an instance in db2 ?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What techniques will be used to avoid deadlock??
What is alias in db2?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
How connect db2 database to datastage?
Can one database have multiple instances?
What is the advantage in De-normalizing tables in DB2?