Interested to Buy Any Domain ? << Click Here >> for more details...
can any one expalin check point with an example?
- 1 Answers
- 5225 Views
- I also Faced
- E-Mail Answers
chek point is used to when more than one record update in
ur cobol/jcl pgm using RD parameter with chekpoint
is mainrole.because every 100 record or userdefine with
chek your result table.abnormally terminated ur pgm not
updated where i mention your last check point.
Rd parameter following types.
rd=restart
rd=rnc(restart no ckekpont)
rd=rc(restart with chekpoint)
*every abnormal execution system automatically restart
(using checkpoint with restart option)
| Is This Answer Correct ? | 2 Yes | 0 No |
How do I delete a table in db2?
What is null value in db2?
How to run db2 command in windows?
How to restart a DB2 program?
Explain correlated sub-queries.
What is reorg?
Can we insert update delete in view?
if i made sme changes in sub pgm wht r the things to be done for this ?
What is db2 instance?
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.
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)
Outputs of explain are with matchcols = 0. What does this signify?
COBOL 
