Select stmt--> This is DML stmt in sql. With this we can retrieve rows o

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

Question Posted / vinodquestion

2 Answers
6327 Views
I also Faced
E-Mail Answers

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

What is the local-storage section?

1148

example for sub strings ? and refernce modifications whit output pls

2317

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

2342

1.Is it possible to move the data from 99.99 to 99v99? 2.What is the CICS-vsam Compilation process? 3.In My GDG 5 generation will be there GDG3 got an abend what will happen? 4.In my GDG first generation is +1 And I want to add the new generation what will happen previous generation? 5.How can you give the PIC clause below conditions A). s9 (reddy), B). s9 (5) occurs 5 times? 6.How override the proc from a particular step? and what is symbolic and override Procs?

5812

How to remove the spaces at the end of each record in the output file of variable length, via cobol program?

1172

how do you reference the variable block file formats from cobol programs

1255

Differentiate cobol and cobol-ii. (Most of our programs are written in cobolii, so, it is good to know, how, this is different from cobol)?

1117

what is the difference between COBOL2 AND COBOL390?

3053

How do you reference the following file formats from cobol programs?

1164

What are 77 levels used for?

1108

How do you get the data to code the BMS macro?

1971

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

1152

How do you code cobol to access a parameter that has been defined in jcl? And do you code the parm parameter on the exec line in jcl?

1203

What is the difference between a binary search and a sequential search? What are the pertinent cobol commands?

1111

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

2221