Answer / mohd rizwan patel

Loading records from PS, or from vsam files to directly into
table, by using LOAD utility of DB2.

What is db2 plan table?

0 Answers  

---

What is a DB2 bind?

1 Answers   Logica CMG,

---

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 are the functions in DB2?

3 Answers   Satyam,

---

What is Reorg Recovery? when will you run it?

2 Answers  

---

---

What are foreign keys?

1 Answers  

---

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,

---

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

What does sqlcabc has?

0 Answers  

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

What is the maximum number of columns in a db2 table?

0 Answers   IBM,

---