Answer / sivakumar sekharannair

EXEC SQL
SELECT
EMPNAME
INTO : HS-EMPNAME(Host variable)
FROM EMPTABLE
WHERE
EMPID = :HS-EMPID(Host variable)
END-EXEC.

Answer / guest

EXEC SQL
SELECT STATEMENT : HOST VARIABLE NAME
END-EXEC.

How does db2 sample database connect?

0 Answers  

---

List out the buffer pools in db2

0 Answers  

---

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---

how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,

---

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 deadlock?

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,

---

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 types of copies can be made with the COPY Utility ?

1 Answers  

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---

How does one remove entries from the SCT02 table?

1 Answers  

---

what is plan? is plan executable or package?

4 Answers  

---