What is check constraint in db2?

0 Answers  

---

What is dbrm? When it will be created?

0 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 the maximum size of a char data type in db2?

0 Answers  

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

---

What is alias in db2?

0 Answers  

---

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,

---

What is the purpose of using commit?

0 Answers  

---

Can we update view in db2?

0 Answers  

---

How does coalesce work?

0 Answers  

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---