Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w select stsmt and cursor ?
- 2 Answers
- 6414 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vinodquestion
Select stmt--> This is DML stmt in sql. With this we can retrieve rows or complete tables from database.
But here in cobol-db2 prog in embededd sql statements it uses. for retrieving rows from tables.
Using this we should retreive only single row from table.(i.e, at where clause)
Cursor stmt--> IF you want to retreive more than one row u need to use this cursors concepts.
IF MY ANSWER IS WRONG CORRECT MY ANSWER>>
Note: Select stmt also used in file accesing situations. i.e, (select file assign to dd1.)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / smartboy
SELECT is SQL query to retrive rows from table in
relational database.
The COBOL program uses the embedded SQL, In order to
process multiple rows in cobol program CURSOR is used.
CURSOR is basically a contolled structure/ mechanisum by
which we can process the multiple data rows in host
language program.
If you observe the syntax of CURSOR it uses the SELECT
query inside it.
| Is This Answer Correct ? | 2 Yes | 0 No |
HELLO FRIENDS, THIS IS JANARDHAN.GADIRAJU, I FACED ONE INTERESTING QUESTION IN COBOL, THAT IS WHAT ARE THE VALUES WE CAN SEE IN HIGHVALUES AND LOWVALUES, CAN U PLEASE GIVE ME THE ANSWER
i want to learn mainframe..any websites and material to learn from basic..? my mail id : rajeswaribe2010@gmail.com
What are the divisions in a cobol program? Which one is the mandatory division among them?
What the difference is between continue and next sentence?
What is the difference between Perform para and perform asaection in cobol?
What is the file organization clause ?
How to traceback if I am getting SOC7 or SOC4 abend? List down the steps
Can the OCCURS clause be at the 01 level?
copy 100 records without using ibm utilities
How to read a record from bottom of a file which is indexed by 'A'.
how can we code index in an array of cobol pgm?
period is missing in the cobol program which error we getting
COBOL 
