before altering a table is it necessary to lock ? if lock
what is it ? how to do ? ifi want to lock a table what is
that command ?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

Explain the use of the WHERE clause.

2 Answers   IBM,


wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,


How can we read records for specific member in CL? AND rpg?

0 Answers  


a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  


what is SPUFI ?

2 Answers  


Is schema the same as database?

0 Answers  


I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,


What is CHECK PENDING ?

5 Answers  


what types of copies can be made with the COPY Utility ?

1 Answers  


What is an alias and how does it differ from a synonym?

3 Answers  


In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,


what is the use of bind parameter, Replace?

5 Answers   IBM,


Categories