Answer / Jitendra Pratap Singh

A Compound Trigger in Oracle is a single trigger that can fire multiple times for each DML (Data Manipulation Language) statement. It consists of multiple individual triggers that are executed based on specific events such as INSERT, UPDATE, or DELETE.

Explain how can you do the explain of a dynamic sql statement?

1 Answers  

---

how to fetch first 100 rows in db2

2 Answers   IBM,

---

What is cursor?

2 Answers  

---

What are the Isolation levels possible ?

5 Answers  

---

What is COPY PENDING status?

6 Answers  

---

What is -904 sql code? How to resolve it?

3 Answers  

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

---

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

---

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

1 Answers   IBM,

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1 Answers  

---

What is meant by the attachment facility?

3 Answers  

---