Answer / islam

-1 indicates that the field contain a NULL value
0 indicates that the field contain valid value
-2 indicates that the field the field contain junk value
due to data conversion error

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---

how to fetch multiple records without using cursor

14 Answers   HCL,

---

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

What is an inner join, and an outer join ?

1 Answers   CTA,

---

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

---

What is load utility in db2?

0 Answers  

---

If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  

---

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

What is the database descriptor?

2 Answers  

---

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

1 Answers   RBS,

---