Answer / Jatin Khanna

Declaration Generator (DCLGEN) is a DB2 command that generates declarations for application programs. These declarations define the structure of database tables, views, and procedures, allowing programs to interact with the database effectively.

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1 Answers  

---

Is schema the same as database?

1 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  

---

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

---

What are the isolation levels possible ?

3 Answers  

---

What types of tables are there in the db2 database?

1 Answers  

---

What is cobol db2?

1 Answers  

---

How is a typical db2 batch pgm executed?

1 Answers  

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

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

9 Answers   CTS, IBM, TCS,

---

Give some example of statistics collected during RUNSTATS?

1 Answers  

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1 Answers  

---