what is the diff b/w select stsmt and cursor ?

Question Posted / visu.kanchamreddy

2 Answers
5189 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the diff b/w select stsmt and cursor ?..

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

what is the diff b/w select stsmt and cursor ?..

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

Post New Answer