What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

---

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

What is copy book?

1 Answers   Thomson Reuters,

---

Is ibm db2 open source?

0 Answers  

---

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  

---

How do you run JCL in cobol program

1 Answers   IBM, Syntel,

---

i want to delete 20th million record how ?

4 Answers   IBM,

---

What is Skeleton cursor table (SKCT)?

2 Answers  

---

What are the different types of base tables?

0 Answers  

---

What are delete-connected tables?

1 Answers  

---

what is rebinding ?

1 Answers   IBM,

---