Answer / Saurabh Kumar Rastogi

In DB2, a commit confirms all SQL transactions that have been executed since the last commit or rollback. Once committed, the changes made to the database are permanent unless subsequently rolled back.

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---

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

6 Answers   TCS,

---

What can the SET option of the Repair Utility accomplish?

1 Answers  

---

Explain an outer join?

1 Answers  

---

How do you run JCL in cobol program

1 Answers   IBM, Syntel,

---

in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,

---

How do I import a csv file into db2?

1 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

What is an intent lock?

3 Answers  

---

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---

What is concurrency?

1 Answers  

---