Answer Posted / guest

It is used relate more than table using RDBMS.For example
if you two table TAB1,TAB2.TAB1 which has column empno with
value ,TAB2 which has same value as previous mentioned TAB1
value.

Row in one table that are related Row in another table .

What is isolation level in db2?

1065

---

What is ibm db2 database?

1061

---

What is null in db2?

1068

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8372

---

What is the maximum No of rows per page?

1108

---

What is the use of db2 optimizer?

1171

---

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 ?...

4370

---

What is the physical storage length of date data type?

1304

---

Define db2 and its databases?

1109

---

What do you mean by cursor?

1029

---

What is meant by explain?

1190

---

What is dbrm? When it will be created?

1084

---

What is the use of predicate?

1083

---

How to find primary key of a table in db2?

1111

---

What is null indicator in cobol db2?

1106

---