Answer Posted / 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.

What is the difference between drop table and delete table?

1197

---

How to run db2 command in windows?

1181

---

What is collection in db2 bind?

1001

---

What is copy pending and check pending in db2?

994

---

Before you give the explain statement, what are the prerogatives?

1021

---

What is image copy in db2?

1000

---

Explain various types of locks in db2?

1131

---

What is the use of dclgen in db2?

1076

---

What is meant by explain?

1119

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4293

---

What is a system catalog table in db2?

1178

---

What are foreign keys in db2?

1093

---

What is the syntax for FETCH in DB2 ?

1195

---

How can you do the explain of a dynamic sql statement?

1061

---

How does a cursor work?

971

---