Answer / mehdee

- The above answer is right, but before print check your
output file and see how many bytes of the Record length
being 4092 you need to have, then use FILEAID and copy your
output into a file with the record length you need and the
Record format = FB, then print this new file.

Answer / sarath

When you are going to enter into the SPUFI, you need to
specify the output dataset. Then only you can enter into
spufi else you can't enter. so if you want to print the
output then print that output dataset.

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,

---

What are types of indexes?

0 Answers  

---

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  

---

What is the difference between static and dynamic SQL?

1 Answers  

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

What is a Foreign Key?

0 Answers   Tavant Technologies, Zensar,

---

define clustering index.

0 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

---

What is the use of dclgen in db2?

0 Answers  

---