Answer / lu

Sure you can...union is like to check the existence row in
many differents tables...

Answer / krishna

Deafnetly you can use,

if union is coded in cobol-db2 program cursor declaration
is mandatory

Answer / srikanth alla

no

Answer / pramod

yes we can

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

---

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

---

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

---

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  

---

what is + sign and -ve sign for sql code ?

1 Answers   TCS,

---

Mention the definition of cobol in varchar field.

0 Answers  

---

What is package in db2 mainframe?

0 Answers  

---

Comment whether the cursor is closed during commit or not.

0 Answers  

---

How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,

---