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 do you define single dimensional array and multidimensional array in your cobol?

767


Have you used the sort in your project?for this type of questions any working on real time project give the eg. with real time scenario.

2155


In which area will you utilize 88 level items in cobol?

809


2 input fles: 2 flat files, with different number of records. both are having unique key for each record and already sorted in ascending order . match these files using unique key and in output only matching key value has to be written. please procide cobol logic

2257


I have a program with an Array of 5000 occurences which is being passed from 5 sub levels to the front end screen. Thess 5 programs using each 5*2 = 10 different arrays with size as 5000. This is causing the transaction to utilize more storage consupmtion. I am looking to reduce the storage consumption. As part of that initially i thought Dynamic array may solve my problem. After viewing the comments given i see its same as normal array. IS there any other way we can resolve this issue?

1311






What is redefines clause in COBOL?

927


How did the release of cobol/370 version 1.3 improve the performance of release 1.1?

754


i want to learn mainframe..any websites and material to learn from basic..? my mail id : rajeswaribe2010@gmail.com

1885


Can we change the password using ALTER? anyone tried and changed?

1632


Write some characteristics of cobol as means of business language.

708


Name the divisions, which are available in a cobol program?

799


What is the difference between perform … with test after and perform … with test before?

1002


Is it possible that the redefines clause has different picture clauses compared to the one it redefined?

769


IF I mention stop run in CICS what happens?

1987


1.give the details about WHEN OTHER. 2. how many form are available in evaluate.

1717