Interested to Buy Any Domain ? << Click Here >> for more details...
What is read-only cursor?
- 1 Answers
- 6665 Views
- I also Faced
- E-Mail Answers
Answer / s
Read-only cursor is a cursor that is defined with FOR FETCH
ONLY clause. The curosor is defined with SELECT, SELECT
INTO.
| Is This Answer Correct ? | 2 Yes | 4 No |
Is ibm db2 open source?
What is the significance of DB2 free space and what parameters control it?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
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.
What is a system catalog table in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)
what is the Foreign key? explain?
what are the max. & min. no. of partitions allowed in a partition tablespace?
Differentiate between cs and rr isolation levels? Where do you specify them?
How do you concatenate the firstname and lastname from emp table to give a complete name?
How to find the maximum value in a column in the db2 database?
COBOL 
