Answer / girish kumar

STATIC CALL DYNAMIC CALL
1. call with in the program is 1. call outside of the prog
called static call is called dynamic call.

2. Main program and sub program 2. Main program and sub-
both are stored in same load program stored in
module. different load
modules.

3. It will reserve some space to 3. It doesn't reserve
sub-program before the space for sub-prog
execution. before the execution

By the load module we can identify weather static
call or dynamic call, both main and sub programs stored
in same load module that is main program.

How do I add a column to a table in db2?

0 Answers  

---

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,

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---

What is the reason behind not using select * in embedded sql programs?

0 Answers  

---

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  

---

What is explain in db2?

0 Answers  

---

What is buffrpool? Where we use it ?

2 Answers   Tesco,

---

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,

---

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  

---

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

---

What is a collection?

3 Answers  

---