Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  

---

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

0 Answers  

---

IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance

2 Answers   Cap Gemini, IBM, Infosys,

---

What are the components used in smp and massively parallel processing (mpp) machines?

0 Answers  

---

What are some commonly used bteq scripts?

0 Answers  

---

What is the maximum number of dml can be coded in a multiload script?

0 Answers  

---

suppose one Cylinder split data blocks are moved from where?

1 Answers  

---

Highlight the differences between Primary Key and Primary Index.

0 Answers  

---

Explain the term 'columns' related to relational database management system?

0 Answers  

---

1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?

3 Answers  

---

I want to write one query How to get Matched records and unmatched records in table?

4 Answers   TCS,

---

what is single value and Multivalue ?

1 Answers   IBM, Wipro,

---