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

Give some examples of command terminators?

751


What is rmode(any) ?

680


input= ,,,, mainframe training ,,, hyderabad .... location.... output1=$ mainframe training in hyderabad location$ output2=**** mainframe training in hyderabad location ****. In this pgn when we give input considering the spaces the output is displayed in this format.Like in the place of ,,,, $ should be displayed likewise.So please helpmeout.

1776


When is inspect verb is used in cobol?

671


Hi pls anybody tell me about " ANALYSIS DOCUMENT PREPARATION AND ESTIMATION OF TASK " (in real time project)."I want to update a sequential file in my project" for that purpose i need both structures i mean analysis document and estimation of task.

1697






How do get the result of your program directly on your pc?

1878


What are the cobol coding sheets?

658


Name some of the examples of COBOl 11?

2676


State the various causes of s0c1, s0c5 and s0c7.

657


what is s000 u4087 error? please give the all error codes in cobol,jcl.

17026


How many sections are there in data division in COBOL?

676


What is the difference between external and global variables in COBOL?

811


How do define dynamic array in cobol.

669


What is an in line perform? When would you use it? Anything else you wish to say about it.

641


What guidelines should be followed to write a structured cobol prgm?

668