Thanks to all who responded.
I got this from Cathlene Mc Rae at HP
So it appears if the primary key has duplicates, the rewrite writes to
the chain head not the current record. The recommend way to do the
update is with fupdate.
I changed REWRITE to FUPDATE and that took care of the problem.
Mike
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Michael Caplin
Sent: 16 May 2006 21:24
To: [log in to unmask]
Subject: [HP3000-L] ksam rewrite problem
I have A ksam file with one key (duplicates allowed).
Ex:
Key data-field
A 001
B 002
C 003
C 004
D 005
E 006
I start at key C, read a record and update the data field to X
I read another rec (the next C) and update the data field to Y
I then stop because I only wanted to update the 'C' recs.
At the end, the 2 C recs are as follows:
C YYY
C YYY
The data portions of both are the same.
I've tried NM and CM KSAM.
The code is NM COBOL.
I've tried COBOL start/read/rewrite as well as
the intrinsics (CKSTART/CKREAD/CKREWRITE).
The manuals do indicate some odd things happening with record
pointers but only when changing keys and I'm not doing that.
Has anyone run across this ?
Mike
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
The contents of this email are confidential to the intended recipient
and may not be disclosed. Although it is believed that this email and
any attachments are virus free, it is the responsibility of the
recipient to confirm this.
Smith & Williamson Corporate Finance Limited - A member of the London
Stock Exchange.
A member of M&A International Inc. http://www.mergers.net Registered in
England No. 4533970. Authorised and regulated by the Financial Services
Authority
Smith & Williamson Investment Management Limited, Registered No.
976145. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Pension Consultancy Limited - Independent
Intermediary. Registered No. 3133226. Authorised and regulated by the
Financial Services Authority.
Smith & Williamson Fund Administration Limited, Registered No. 1934644.
Authorised and regulated by the Financial Services Authority.
Smith & Williamson Limited - A member of Nexia International.
Registered in England No. 4534022. Regulated by the Institute of
Chartered Accountants in England & Wales for a range of investment
business activities.
NCL Investments Limited, Registered No. 1913794.
Member of the London Stock Exchange authorised and regulated by the
Financial Services Authority.
Registered Office: 25 Moorgate, London EC2R 6AY
Telephone: 020 7131 4000 http://www.smith.williamson.co.uk
Nexia Smith & Williamson Audit Limited - A member of Nexia
International. Registered in England No. 4469576.
Nexia Smith & Williamson Audit Limited is a company registered to carry
out audit work and is regulated for a range of investment activities by
the Institute of Chartered Accountants in England and Wales. Smith &
Williamson Limited is a separate company that provides professional
resources and certain services to Nexia Smith & Williamson Audit Limited
under the terms of a formal agreement on an arm+IBk-s length basis.
Registered Office: 25 Moorgate, London EC2R 6AY
Telephone: 020 7131 4000 http://www.nexiasmith.williamson.co.uk
All telephone calls are recorded for business purposes.
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
