|
View previous topic :: View next topic
|
| Author |
Message |
nbalajibe
Warnings : 1
New User
Joined: 28 Nov 2006
Posts: 75
Location: India
|
|
|
|
Hi,
In one of our applications we are loading a DB from a flat file using COBOL program. As per the design one of the fields of a record is updated depending upon the value of the other, for example if the contents of the input file are
| Code: |
111 ABC N N
222 CDE N N
333 ABC Y N |
As per the design while inserting the third record the first record should be updated as below
But we are giving checkpoints for every 1000 records. Our doubt is whether we would be able to update the first record if the checkpoint is not issued (i.e. if it lies within the 1000 records)
Thanks in advance,
Balaji |
|
| Back to top |
|
 |
Sandy Zimmer
Active Member
Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE
|
|
|
|
| How long have you estimated your "load" process will run? If this is truly a load process, then perhaps you should consider loading with the databases offline - not as a BMP. |
|
| Back to top |
|
|
Mahendran3784
New User
Joined: 04 May 2007
Posts: 20
Location: INDIA
|
|
|
|
| Sandy- how does this helps in his case? actually his requirement is to update the uncommitted record. |
|
| Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE
|
|
|
|
Quite some time ago we spent quite a lot of time trying to help someone with a problem only to find out that we misunderstood the problem. Please read the following link and provide us with more info on the problem.
ibmmainframes.com/viewtopic.php?t=26538 |
|
| Back to top |
|
|
nbalajibe
Warnings : 1
New User
Joined: 28 Nov 2006
Posts: 75
Location: India
|
|
|
|
| Approximately the load process is expected to run for around 3 hours. As Mahendran has said my question is regarding reading uncommitted data. |
|
| Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE
|
|
|
|
| Let's take a step back - to the beginning of your posts. You are reading an IMS database - I think - not a DB2 table. In IMS, before you "update" - which is what I THINK you are doing - you must get and hold the record before issuing the REPL command. If the database is in existence, then you are not LOADING it - you are either insterting (ISRT) - if the segment on your flat file does not exist - or if it does exist, you are updating it. So, what is your definition of "uncommitted data"? |
|
| Back to top |
|
|
nbalajibe
Warnings : 1
New User
Joined: 28 Nov 2006
Posts: 75
Location: India
|
|
|
|
Yes Sandy, it is a IMS database. We are inserting records and giving a checkpoint after 1000 records.
As you have said for updating a record we have to hold it. My doubt is whether we can hold a record (for updating) if no checkpoint was given after the insert call (this insert call is also given from the same job). |
|
| Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE
|
|
|
|
| As I understand it, you are concerned that you get-hold a segment - add to your checkpoint counter - then issue your checkpoint before you update the segment? You could adjust your logic to NEVER issue a checkpoint until AFTER your update. |
|
| Back to top |
|
|
|
|
