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.

What is db2 command?

0 Answers  

---

What is Declaration Generator(DCLGEN)?

1 Answers  

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

How would the varchar column remarks defined?

0 Answers  

---

Explain correlated sub-queries.

0 Answers  

---

---

What is the significance of DB2 free space and what parameters control it?

1 Answers  

---

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

---

What is a Cartesian product?

2 Answers  

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

what is difference between random and sequence file access

1 Answers   Syntel,

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---