Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

0 Answers   TCS,

---

What is an extended stored procedure?

1 Answers  

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  

---

Which four data types cannot be used as a return type from a user-defined function?

0 Answers  

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  

---

I have a few records all are same structures data, I want to store data in multiple targets how

0 Answers   CTR, Infosys, Polaris,

---

How to use online Backups?

0 Answers  

---

How to generate OIDS

0 Answers  

---

What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?

5 Answers   IBM,

---

How to customize error conditions.

0 Answers  

---

What is a self join? Explain it with an example?

16 Answers   TCS,

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers  

---