Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of coding FETCH in a SQL SELECT query?
Explain with an example in Detail?
- 4 Answers
- 8111 Views
- I also Faced
- E-Mail Answers
Answer Posted / siri reddy
Inorder to select first n number of rows fetch is used in
conjunction with select statement
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Define declaration generator (dclgen).
What is rct?
What action db2 takes when a program aborts in the middle of a transaction?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How to compare data between two tables in db2?
what is db2 restart?
What is the maximum No of rows per page?
What is the maximum size of a char data type in db2?
What is performance tuning db2?
What is the use of runstats in db2?
Mention the definition of cobol in varchar field.
What is host variable?
What is null indicator in cobol db2?
What is buffer pool in the db2 database?
