Interested to Buy Any Domain ? << Click Here >> for more details...
what happend with out using Commit,when closing cursor and
program?
- 5 Answers
- 15243 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harish
yes, commit-it will save the changes that we done to db2
table
when operation is performed successfully table will be auto
committed its default,suppose if any abends occur all
changes will be rolled back , table will come to original
status
since while updating millions of records somewhere some
abend occurs that time its better to have commit ,so till
upto abend whatever changes occured in table will be
saved.....
pls let me know if u have any queries
HARISH POOMGAME SHIVAPPA
NIIT TECHNOLOGY
KOLKATA
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / praveen
If the program ran successfully, then it will commit.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / guna
If there is no commit while closing cursor or a program,
processed records are lost when an abnormal end occurs.
Say, if due to the execution of the program some rows are
inserted/deleted/updated in a table, those changes will be
lost.
It is a better practice to give commit after every
insertion/updation queries and before terminating a
program.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / vish
True that we should Explicitly COMMIT the data instead of
depending on auto comit. But COMMITing after every
insert/update of data is not a very good option. Explicit
COMMIT incurs an overhead and makes the processing slow. So
if we are inserting/updating a large number of data into
table, COMMIT after every such update will make the Job
very slow, which in most of the cases, is not preferrable
for production Jobs. In fact, the COMMIT frequency should
be chosen very carefully for every program (please note we
should not have a common COMMIT frequncy for all the
programs as the data being proceesed by different programs
will be different and hence their importance & time to re-
process them also differs) keeping in mind that neither the
performance should be degraded nor the data should be lost.
Suggesstions are Welcome!!
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mani
The answer to the question is pretty simple and straight.
Auto commit happens when the cursor is closed.
If at all there is any abend then the changes made will be lost.
| Is This Answer Correct ? | 4 Yes | 3 No |
List down the types of triggers in the db2 database?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
How will fetch last 5 rows from table in db2
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
is there any restrictions for unions ?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
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.
What is data manager?
What is clone table?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
My SQL is not performing well. Describe how will you fine tune it?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
COBOL 
