Answer / randy

By Using Cursor, we can fetch more than one record from database.

Answer / azharuddinsyed

Cursor is used to fetch more than one row at a time from db2 table.

Answer / manhem

To fetch more than one row from DB2 table, Cursor is used

Hi................... I have records like this aaaa cccc bbbb And i want output like this bbbb cccc aaaa How can it possible ?. Note:Please make sure records are in unsorted order. somebody plzzz help me.

1 Answers  

---

what is label record is standard or omitted in file description of data division?

3 Answers   IBM, TCS,

---

What is IMPACT analysis?

2 Answers   IBM,

---

wirte a pgm in using files in which we hav 10 ,20,30 40...100 records in inputfile and i want them to be send to outputfile in reverse order. PLZ HELP ME OUT .........THIS IS A RECENT QUESTION IN IGATE..

5 Answers   iGate,

---

if a=b how the flow will complete??? perform test through test-exit. perform activa through activa-exit. test. if a=b then next sentence else move a to c. test-exit. exit. activa. -- -- activa-exit. exit.

1 Answers   IBM,

---

i have two file, each file having : file1 is having 2 fields field1 field2 file2 is having 3 fields field1 field2 field3 my req is to make it one file like: field1 field2 field1 field2 field3 if anyone know please send me syntax, i tried this with DFSORT but could not succeed.

9 Answers   Syntel,

---

how to convert vsam table into DB2 table?

1 Answers   IBM, Wipro,

---

What are the different data types in cobol?

0 Answers  

---

write a program to eliminate duplicate records in a input file and send them to output file.THIS IS IGATE RECENT QUESTIONN.....JUST 1 WEEK BACKKKK...

5 Answers   iGate,

---

In a program, variables are used but no DB2 involved in it. Can you call it as host variables??

4 Answers   EDS,

---

How do u debug a S0C7 abend? (aswered till we get the field which caused that) After knowing the field which caused that how do u know the record which caused that if it is in production env? (dumb) Ok let us assume that we got to know that 100th record caused that and I wanted to skip only 100th record from the file and process from 101th. How to do that in JCL using SORT? (tried with STOPAFT but ended up dumb when he said smthing else is ther)

3 Answers   IBM,

---

I have a occurs for 100 times but it has executed 101 time what could be the reason?

4 Answers  

---