Answer / mehdee

Example:
EXEC SQL
FETCH AA_CURS
INTO :Host-name1, Host-name2, ...
EXEC-END

Note: Host-names listed are one to one related to the
Columns at DECLARE AA_CURS, and are INCLUDEed from it's
DB2 DECLGEN name in the program.

Answer / sadiq afroze

Using the DSECT, followed by lines of - 'data items DS
datatype'.

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

---

How do you stop a db2 database in linux?

0 Answers  

---

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,

---

What is the command used by TSO users to invoke DB2?

2 Answers   IBM,

---

What is Reorg Recovery? when will you run it?

2 Answers  

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  

---

What is syscat in db2?

0 Answers  

---

What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,

---