Interested to Buy Any Domain ? << Click Here >> for more details...
what is check point and restart Logic ? why do we go for
that ??
- 2 Answers
- 27472 Views
- CGI, UST, Xansa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / milky
Checkpoint-Restart logic is used when your program performs
a large number of database updates or inserts. If you want
to process and insert say 1000 records in a table, and your
program abends at 726th record, then if the checkpoint
frequency has been set to 100, then, on restart the program
will start processing from 701th record as each processing
of 100 records results in a COMMIT.
| Is This Answer Correct ? | 68 Yes | 5 No |
Answer / harsha
check point and restart logic are mainly used when our
table has 1000 records and we are getting abend after 100
records and we want to start the execution after 100th
record we use this.for this we have to use check points for
every 100 records
| Is This Answer Correct ? | 41 Yes | 12 No |
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
What is db2 look?
What is a base table?
How do I change the column size in db2?
Is the primary key a clustered index?
If I have a view which is a join of two or more tables, can this view be updatable?
what needs to be done if a table is in copy pending / check pending status?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
How to fetch the last row from the table in SQL (db2)?
Explain the function of data manager.
COBOL 
