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
Why did you choose to work with ibm mainframe cobol programming?
Whats the difference between search & search ALL?
How are the next sentence and continue different from each other?
I need to compare 3 variables(dates) and do some processing based on the earliest date. There could be more then 1 date record in any of the 3 fields. What is the best way to code this?
How do you get the data to code the BMS macro?
what is the difference between COBOL2 AND COBOL390?
)If there are 10 steps in GDG, if I want to refer the step2 after step5 . what should I do?
How do define dynamic array in cobol. how do you define single dimensional array and multidimensional array in your cobol?
Can we change the password using ALTER? anyone tried and changed?
When is inspect verb is used in cobol?
Why do we code s9 (4) comp. Inspite of knowing comp-3 will occupy less space?
What rules are followed by the search verb.
What are the different rules of SORT operation?
What is inspect in cobol ?
What is a SSRANGE and NOSSRANGE?