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.)

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.

Have you code any new programs in COBOL ? What is the functionality of the programs?

2 Answers   Patni, Xansa,

---

can we print comp 3 stmts how ?

3 Answers   Accenture, TCS,

---

What is the output generated by the following code? 01 GRP-I. 05 SUBFLD1 PIC XX VALUE "AB". 05 FILTER PIC X(6) VALUE SPACES. 01 GRP-2 REDEFINED GRP-1. 05 SUB-FLD2 PIC XX. 05 SUB-FLD3 PIC XX. 05 FILTER PIC X(4). IF SUB-FLD1 NOT = SPACES DISPLAY "SUBFLD1" MOVE "ABBCCD" TO GRP-1 IF SUB-FLD3 = SPACES DISPLAY "SPACES" ELSE DISPLAY "SUBFLD3" DISPLAY "END" ELSE DISPLAY "SPACES" DISPLAY "END". (a) SUBFLD1 SUBFLD3 END (b) SPACES END (c) SUBFLD1 END (d) SUBFLD1 SPACES

7 Answers   TCS,

---

Which Search verb is equivalent to PERFORM…VARYING?

0 Answers  

---

How do pass the values to the parameters in cobol

2 Answers  

---

In EBCDIC, how would the number 1234 be stored?

2 Answers   TCS,

---

What are the different rules to perform a Search?

0 Answers  

---

What are the various section in data division and briefly explain them.

0 Answers  

---

Using string statement.Is coding three destination string from one source string possible in one code?or three codes for every destination string of one source string.?thank you

1 Answers   BPL,

---

Which is the default, TEST BEFORE or TEST AFTER for a PERFORM statement?

0 Answers  

---

wht is structured cobol pgm and non structred cobol pgm ?

1 Answers   CTS, DELL,

---

Can anyone tell me how to handle the array beyond the limit. If we have an array or a table which can handle 5000 records but now we have to compensate 20000 records with the same array? how to handle the situation.

2 Answers  

---