Answer / mr. cooooool

SELECT CURRENT DATE, CURRENT TIME FROM SYSIBM.SYSDUMMY1;

What is syscat in db2?

0 Answers  

---

What is cursor in dbms?

0 Answers  

---

List out the three types of page locks that can be held.

0 Answers  

---

What is the role of the data page in the db2 database?

0 Answers  

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  

---

What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  

---

What is ALTER ?

3 Answers  

---

select 100 records from million records ?

2 Answers   Verizon,

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---