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 ?
Explain the use of the WHERE clause.
wht steps we need will coding cobol and db2 pgm ?
How can we read records for specific member in CL? AND rpg?
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.
what is SPUFI ?
Is schema the same as database?
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?
What is CHECK PENDING ?
what types of copies can be made with the COPY Utility ?
What is an alias and how does it differ from a synonym?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
what is the use of bind parameter, Replace?