What is a db2 collection?
No Answer is Posted For this Question
Be the First to Post Answer
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What is deadlock in db2?
What is a DB2 access path?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What are the various locking levels available?
How to create db2 table in mainframe?
What does reorg do in db2?
What is the reason behind not using select * in embedded sql programs?
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
Explain the contention situations caused by locks?
Explain the contents that are a part of dclgen.