Answer / naveen

When this primary key is also a foreign key to another
table and that table is not having the value you are trying
to insert.

RI constraint doesn't allow you to insert a primary key
value into your table if its not present in table your are
having constraint with

Answer / pawan

when the value violates the rule of primary key....new
insert value must be unique.

What is db2 connect?

1 Answers  

---

What is package in cobol db2?

1 Answers  

---

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1 Answers  

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1 Answers  

---

is it compulsory commitment control in journal?

1 Answers   TCS,

---

How would you find out the total number of rows in a db2 table?

1 Answers  

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---

What is a db2 schema?

1 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

What are the benefits of using the db2 database?

1 Answers  

---

What is collection in db2 bind?

1 Answers  

---

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

---