Interested to Buy Any Domain ? << Click Here >> for more details...
Can we declare cursor in Procudere division or open the
cursor in the Working storage section.
Is there any particular rules in the usage of cursors lifecycle
- 1 Answers
- 8749 Views
- Infosys, I also Faced
- E-Mail Answers
Answer / omkar panda
yes we can declare cursor in procedure division but we cant
open the cursor in working-storage section as it is an
executabale statement.the lifecycle of cursor is as below
1>declare cursor
2>open cursor
3>fetch cursor
4>close cursor
| Is This Answer Correct ? | 20 Yes | 2 No |
What parameters are used to control the free space in DB2?
What is the role of schema in the db2 database?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
How to resolve -504 sql code in DB2?
When is the results table for the query in a DECLARE CURSOR statement created?
What is read-only cursor?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
What Utility is used to migrate DB2 from one release to the next?
How to know the primary key of a table without defining the primary key in the table?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
COBOL 
