What are union and union all?

0 Answers  

---

How can you split a table in to exactly half?

7 Answers   HSBC,

---

Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

What do you do to keep the cursor from closing after a commit?

1 Answers  

---

What is a root page?

1 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

How to create a table using embedded sql?

1 Answers  

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  

---

Define data page.

0 Answers  

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

what is Static and dynamic linking

1 Answers   Virtusa,

---