Answer / i go crazy

Union can be used in a cobol db2 pgm, only restriction is it has to be operated using a CURSOR.

Answer / lu

yes, u have to code with the cursor.....

Answer / mehdee

- There is no restriction for UNIONs in DB2 COBOL coding,
but you can think of logical restrictions, for example if
the DB2 tables are so big that your program will run fast
if just access them individually as needed.

Answer / srikanth alla

WE CAN'T CODE union IN COBOL-DB2 program

Request to database but database is not available so what is was abend is raised?

2 Answers   UST,

---

On the create tablespace, what does the CLOSE parameter do?

1 Answers  

---

What is the clustering index in the db2 database?

0 Answers  

---

What is concurrency in db2?

1 Answers  

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

how can i pull up a query which was previously stored in qmf

3 Answers  

---

Hi All, In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)

1 Answers  

---

Which catalog tables contain authorization information?

1 Answers  

---

What parameters are used to control the free space in DB2?

0 Answers  

---

How would you print the output of an SQL statement from SPUFI?

2 Answers  

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  

---