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

Answer Posted / secret service

Add FETCH FIRST 1 ROW ONLY to your query.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you please let me know the centre name of INS certification in Kolkata.

1700


Describe the cobol database components?

664


What are the rules of the move verb?

687


What is the Purpose of POINTER Phrase in STRING command in COBOL?

702


Which mode is used to operate the sequential file?

648






What is comp-1 and comp-2?

746


What are various search techniques in cobol? Explain.

629


How do we get current date from system with century in COBOL?

775


How to get the last record in vsam file in cluster? And how can you get the kids file records into your cobol program?

720


) how do u code after getting data?

1572


How to find out the closest prime number of an input number? I believe it has something to do with SEARCH and COBOL Linear Array.

3697


what is s000 u4087 error? please give the all error codes in cobol,jcl.

16993


How do define dynamic array in cobol.

650


how to move the records from file to array table. give with code example

2200


Write the code implementing the perform … varying.

623