Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use select query in a loop to fetch multiple rows in
a COBOL PROGRAM? If so, what is the advantage of cursor?
- 1 Answers
- 6053 Views
- UST, I also Faced
- E-Mail Answers
Answer / hitendra valluri
As per my knowledge if we loop the select query it retrieves the same data untill we explicitly handle the where clause to retrieve the rows. Unlike select CURSOR fetches all the rows and allows the program to process 1 at a time.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What are union and union all?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
What is concurrency?
What does DSNDB07 database do?
What is the picture clause of null indicator variable?
Explain packages.
On which levels locks can be applied?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
How do you retrieve the first 5 characters of firstname column of db2 table emp?
COBOL 
