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.

How do I add a column in db2?

0 Answers  

---

Why do we bind in db2?

0 Answers  

---

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 Answers   IBM,

---

select 100 records from million records ?

2 Answers   Verizon,

---

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers  

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,

---

On the create tablespace, what does the CLOSE parameter do?

1 Answers  

---

how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,

---

What is DCLGEN ?

2 Answers  

---

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

---