Answer Posted / sujeesh

32

How to compare data between two tables in db2?

664

---

Is db2 a database?

578

---

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 ?...

3799

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

661

---

What are the different types of base tables?

589

---

---

Explain how can you do the explain of a dynamic sql statement?

669

---

What is coalesce in db2?

691

---

How to find schema of a table in db2?

576

---

What is commit in db2?

600

---

How to find primary key of a table in db2?

621

---

what are bind concepts in db2 cobol?

655

---

What is null indicator in db2?

609

---

Explain the contention situations caused by locks?

600

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1632

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

621

---