I know my query will return more than one row but I don't want cursor what should I do?

Answer / secret service

Add FETCH FIRST 1 ROW ONLY to your query.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More COBOL Interview Questions

where do u use low-value and high value in cobol

3 Answers   CGI,

How To move a value to an array using move verb?

3 Answers   IBM,

How is sign stored in Packed Decimal fields and Zoned Decimal fields?

6 Answers   ABC, TCS, HCL,

how we rectify soc7 and soc4 errors in project?

1 Answers   TCS, Anaxis,

what is ASRA, AEY9?

2 Answers   IBM,

Following questions were asked in Capegemini on 8th sep,2012 mainframe test 1.)Condition code for dul recors in VSAM- 2.) Is NULL or =NULL in Select statement 3.)max size of CI 4.)What happens after CI is full 5.)Ques on COND parameter 6.)which among following can not be rolled back a)delete table b.)droptable c)Update d.)insert 7.)groupby and orderby sql querries 8.)Max extents in VSAM file 9.)quesn on DPRTY=(1,10) 10.)range of condition codes in COBOL 11.)occurs clase can not be used at which level? 12.)delimiter in jcl 13.)sort card for file in PGM=SORT 14.)PIC(6) value 120056 possible? 15)question on BLKSIZE Is (20,20) and (20,10) possible? 16.)number of bytes in RDF 17.)Can we use index in WS-section or LK-section 18.)Verify command in IDCAMS used for? 19.)question on Alternate Index 20.)Return code of file attribute mismatch 21.)In which format COBOL variables stored? 22.)what is Alternate of HANDLE? 23.)can SUM,AVG,MIN,ROUND used in numeric and char variable data types? 24.)What is the datatype of FILE STATUS codes in WS-section?

2 Answers   Cap Gemini,

Minimum how many Number of Paragraphs are there in ID- Divison?

7 Answers   IBM,

s9(18) comp-3:: What is the size of memory it takes internally?

4 Answers  

What is 77 level used for ?

12 Answers   IBM, iGate,

) what is the difference between AID and HANDLE AID?

0 Answers   IBM,

What should be the sorting order for SEARCH ALL?

5 Answers  

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

4 Answers