Hi Team,
Please tell me, If i don't declare the cursor in the program
and i have given open and fetch and close, then what error
will get.
Answers were Sorted based on User's Feedback
Answer / ramesh
Rather I say ,Specofically, It will be Identified at Pre
compilation of your COBOL - DB2 source code.
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / dharani
Db2 return code would be -504 since the cursor is not
declared.
-501 - cursor not opened
-502 - opening cursor which is already opened
-503 - update column not specified in cursor while
declaring the cursor for updating some of the columns in
the table.
| Is This Answer Correct ? | 0 Yes | 4 No |
Write a query to retrive partial string.
What is the difference between base table and view?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What is Declaration Generator(DCLGEN)?
What is a synonym ?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
When do you use the IMAGECOPY?
Can we update view in db2?
What is the role of the data page in the db2 database?
What are column-name qualifiers used?
What are the abend codes occour in ur latest PROJECT in DB2