Answer / lu

Sure you can...union is like to check the existence row in
many differents tables...

Answer / krishna

Deafnetly you can use,

if union is coded in cobol-db2 program cursor declaration
is mandatory

Answer / srikanth alla

no

Answer / pramod

yes we can

Which catalog tables contain authorization information?

1 Answers  

---

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  

---

What happens to the PLAN if index used by it is dropped?

1 Answers  

---

What will the COMMIT accomplish?

5 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

---

How to rename a table in DB2 ?

0 Answers   MCN Solutions,

---

Name some fields from SQLCA

1 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,

---

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

---

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

---