Answer / mr. cooooool

SELECT CURRENT DATE, CURRENT TIME FROM SYSIBM.SYSDUMMY1;

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,

---

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers  

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

What is db2 isolation?

2 Answers  

---

What is the difference between TYPE 1 index & TYPE 2 index

1 Answers   IBM,

---

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  

---

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

how can u understand the end of the table ?

1 Answers   TCS,

---

What is db2 bind process?

0 Answers  

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

0 Answers  

---

where will u check for sqlcode ?

2 Answers   TCS,

---