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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many bytes S(8) comp field occupy and its maximum value?

1630


What is difference between static and dynamic call in cobol?

777


What is the difference between next sentence and continue in cobol programing language?

708


How do u write test cases?

1634


What is the LINKAGE SECTION used in COBOL?

889






What rules are to be followed while using the corresponding options?

638


What are the different rules for performing sort operation?

759


What is the difference between comp and comp-3 usage?

678


How you can characterize tables in cobol?

716


What is the difference between binary search and sequential search?

638


What is the difference between Structured COBOL Programming and Object Oriented COBOL programming?

677


what is amode(24), amode(31), rmode(24) and rmode(any)?

698


) what is the difference between AID and HANDLE AID?

1635


Write the code implementing the perform … varying.

644


What is a scope terminator give example?

655