Answer / s

Host Variables are data structures used to recieve column
values from the table.

Answer / praveen

host variable is db2 table equalent variable.

Answer / azharuddinsyed

Host variable is a cobol equivalent variable for a table column.

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

3 Answers  

---

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

---

how to fetch multiple records without using cursor

14 Answers   HCL,

---

Write a query to retrive partial string.

2 Answers  

---

What is the connection string to connect to the DB2 Database ?

0 Answers   MCN Solutions,

---

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,

---

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,

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

---

what is the soft code for deadlock ?

2 Answers   Logica CMG,

---

What is a db2 schema?

0 Answers  

---