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.

What is a predicate?

1 Answers  

---

How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

How does DB2 use multiple table indexes?

1 Answers  

---

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

0 Answers  

---

How do we specify index to include or not during bind process.

0 Answers   Satyam,

---

What is the purpose of the DSNC transaction ?

1 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

Can we install 2 different versions of Db2 on same mainframe?

3 Answers  

---

How is the value function used?

0 Answers  

---

how do you resolve -805?

3 Answers   HCL,

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  

---