Is the primary key a clustered index?
No Answer is Posted For this Question
Be the First to Post Answer
what are extents?
Why cursor is used in db2?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
can all users have the privilage to use the sql statement select * (dml)?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
List out the three types of page locks that can be held.
Suppose if I need to update a column, how you do that using cursor?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
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.
What is the use of dclgen in db2?
What are the bind parameters ibm db2?