can we drop column from a table

7 Answers   INDUS,

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

What is DCLGEN ?

2 Answers  

---

When is the skeleton cursor table created?

1 Answers  

---

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  

---

Explain the function done by data manager?

0 Answers  

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  

---

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

What is sqlca’s maximum length?

0 Answers  

---