Answer / vamsikrishnamraju

A foreign key is a referential constraint between two
tables.The foreign key identifies a column or a set of
columns in one (referencing) table that refers to a column
or set of columns in another (referenced) table. The
columns in the referenced table must form a primary key or
unique key.

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

---

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  

---

What is lock escalation in db2?

0 Answers  

---

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,

---

what is a collection?

2 Answers  

---

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  

---

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

---

wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,

---

how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,

---

explain about index with examples

2 Answers   Syntel,

---

What is explain in db2?

0 Answers  

---

What is a trigger in the db2 database?

0 Answers  

---