How can you display the current date & current time ?
Post New Answer View All Answers
If I have a view which is a join of two or more tables, can this view be updateable?
What is phantom read in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How can we read records for specific member in CL? AND rpg?
How to find primary key of a table in db2?
What is deadlock in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What are the full forms of spufi and dclgen and why are they used?
What is explain in db2?
What is a page in db2?
How do you eliminate duplicate values in db2?
What is db2 instance?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is meant by union and union all?