Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Syntax to update and delete from an ESDS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
MARINA JOSEPH

New User


Joined: 11 Jun 2009
Posts: 61
Location: chennai

PostPosted: Wed Jun 17, 2009 5:33 pm    Post subject: Syntax to update and delete from an ESDS
Reply with quote

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
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8154
Location: East Dubuque, Illinois, USA

PostPosted: Wed Jun 17, 2009 5:42 pm    Post subject:
Reply with quote

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
View user's profile Send private message
MARINA JOSEPH

New User


Joined: 11 Jun 2009
Posts: 61
Location: chennai

PostPosted: Wed Jun 17, 2009 5:49 pm    Post subject: Reply to: Syntax to update and delete from an ESDS
Reply with quote

Hi,

Thanks for the information.
Is it possible to give me the syntax to update the record in ESDS.

Thanks,
Marina.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Wed Jun 17, 2009 5:50 pm    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10310
Location: italy

PostPosted: Wed Jun 17, 2009 5:51 pm    Post subject: Reply to: Syntax to update and delete from an ESDS
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm
No new posts WER268A OUTREC STATEMENT : SYNTAX E... frozenblood87 SYNCSORT 12 Sat Aug 26, 2017 9:45 pm
No new posts Delete IMS remote transaction when MO... Sam Singh IMS DB/DC 0 Wed Aug 23, 2017 9:12 pm
No new posts NDM syntax checking without actually ... GAPX1 All Other Mainframe Topics 0 Wed Jun 07, 2017 2:36 am
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us