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

I hav vari declaration like..... 77 a pic s9(9).99. 77 b pic s9(9).99 comp. 77 c pic s9(9).99 comp-3. if i use MOVE 123456789.99 to a,b,c what happen every one working fine ?

1 Answers   Mphasis,


What does EXIT do ?

3 Answers   Deloitte,


Whtz the specialty of 77 level number ?

2 Answers   Infosys,


how to transfer the file from pc to mainframe??

3 Answers  


How to Pass table from a cobol program to another cobol program and how to use that table in called program

7 Answers   Patni, SunGard,


wht r the advantages of 77 level number ?

8 Answers   TCS,


What will happen if we move SPACES to numeric field and ZEROES to alphabetic field?

2 Answers  


Describe the difference between subscripting and indexing ?

2 Answers  


what is the difference between Plan & package?

1 Answers   IBM,


In an EVALUATE statement, can I give a complex condition on a when clause?

2 Answers  


how can we apply for HSBC exam(Mainframe) in India??? i went to their site and was told to submit my CV ,. etc..( totally confusing...)

0 Answers   HSBC, Quest,


Can JUSTIFIED be used for all the data types?

3 Answers  




Categories