View previous topic :: View next topic
|
Author |
Message |
MARINA JOSEPH
New User
Joined: 11 Jun 2009 Posts: 61 Location: chennai
|
|
|
|
Hi all,
Can somebody give me the syntax to update and delete from an ESDS file. In the programs link i only found how to read and write.
Thanks,
Marina. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
From the VSAM Demystified redbook (emphasis added by me):
Quote: |
An ESDS is comparable to a sequential non-VSAM data set in the sense that
records are sequenced by the order of their entry in the data set, rather than by
key field in the logical record, which could be fixed or variable length records.
All new records are placed at the end of the data set. There is no split concept.
Existing records can never be deleted. As far as VSAM is concerned, the record
is not deleted. It is the responsibility of the application program to identify that
record as invalid. If the application wants to delete a record, it must flag that
record as inactive.
Records can be updated, but without length change. To change the length of a
record, you must either store it at the end of the data set as a new record, or
override an existing record of the same length that you have flagged as inactive. |
|
|
Back to top |
|
|
MARINA JOSEPH
New User
Joined: 11 Jun 2009 Posts: 61 Location: chennai
|
|
|
|
Hi,
Thanks for the information.
Is it possible to give me the syntax to update the record in ESDS.
Thanks,
Marina. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Within the document that you did not bother to closely read:
3REWRITE <<<<<<<<<this is how an UPDATE is performed
4DELETE <<<<<<<<<self explanatory (but not for esds which cannot be done) |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
once that has been eshtablished that the <KEY> for a random read of an ESDS is the RBA,
the syntax for the update/rewrite follows the rules of any other update/rewrite
look at the relevant cics manuals ( Link at top of the page ) |
|
Back to top |
|
|
|