Interested to Buy Any Domain ? << Click Here >> for more details...
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
1.give the details about WHEN OTHER. 2. how many form are available in evaluate.
Can we change the password using ALTER? anyone tried and changed?
Why do we code s9 (4) comp. Inspite of knowing comp-3 will occupy less space?
can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there
What is the difference between PIC 9.99 and 9v99 in COBOL?
What is link edit in cobol?
What is the difference between Global and External Variables?
What is the Purpose of Pointer in the string?
What are the various section in data division and briefly explain them.
Which Search verb is equivalent to PERFORM…VARYING?
If you are current on the owner of a set, what is the difference between an obtain next and obtain first? Actually in which topic will we use dis???Plz explain it clearly
What are INPUT PROCEDURE and OUTPUT PROCEDURE?
how do you reference the esds vsam file formats from cobol programs
Explain sorting techniques in cobol program? Provide the sort file definition, the sort statement, its syntax and meaning
I have one ps file in which there are 3 fileds emp_no,emp_name and leave_app.this ps file information give the detail of employee which is going to apply for leave.suppose emp_no=113430,emp_name=ajay,leave_app=1 that means he is going to apply for 1 day leave.and accordingling the table in db2 will be updated means if he has that no of leave in his account then he will get dat leave and updated acc. in table(leave_balance=previous leave present in table-leave_app).Now i want to check whther the updated result is correct or not by comparing the two ps file using IEBCOMPARE or icetool so what is going to be the two ps file and how its is going to be compare.
