Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

EXEC CICS DELETE without specifying RIDFLD

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

New User


Joined: 23 May 2007
Posts: 18
Location: Bangalore

PostPosted: Thu Dec 09, 2010 2:19 am    Post subject: EXEC CICS DELETE without specifying RIDFLD
Reply with quote

Hi ,

What happens when 'EXEC CICS DELETE' command is executed only with the DATSET name (without specifying the RIDFLD).

Does it delete all the records from the DATASET mentioned in the command??
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


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

PostPosted: Thu Dec 09, 2010 2:26 am    Post subject:
Reply with quote

Was there a READ with UPDATE done before, or is there a browse active? If not, no records will be deleted.

If the only option is DATASET, then you cannot delete all records from the file with the command -- you must use the GENERIC option (which in turn has other requirements) in order to delete all records from a file in CICS.
Back to top
View user's profile Send private message
dmithunibm

New User


Joined: 23 May 2007
Posts: 18
Location: Bangalore

PostPosted: Thu Dec 09, 2010 2:30 am    Post subject: Reply to: EXEC CICS DELETE without specifying RIDFLD
Reply with quote

Yeah thanks..

Anyway I got it. If no RIDFLD is specified, the last READ (from the dataset mentioned) is Deleted....
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2502
Location: Atlanta, Georgia, USA

PostPosted: Thu Dec 09, 2010 3:34 am    Post subject: Reply to: EXEC CICS DELETE without specifying RIDFLD
Reply with quote

If you're Browsing and you need to Delete a record which you've just Browsed/Read, you need to save the RIDFLD, issue an ENDBR, issue a Read for Update, issue a DELETE, then restart the Browse, using the saved RIDFLD, using a RESETBR or a STARTBR (increased overhead). If you're using RLS, then you don't need to do this.

You can really be in trouble if the file is NSR (not defined to any LSR Pool) and you could cause a deadly embrace.

Remember, very long NSR Browses don't return control to the QR TCB until an ENDBR is hit or task termination. You DON'T want to cause the QR TCB to go into a wait state.

Otherwise, you're taking a chance of corrupting the data-integrity of the file.

Bill
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 How to Clear all TSQs during CICS sta... Hooman24 CICS 10 Mon Jun 26, 2017 9:46 pm
No new posts CICS Transaction attach count of supp... lind sh CICS 1 Wed Jun 21, 2017 1:33 pm
No new posts Running an REXX EXEC implicitly sho7hills CLIST & REXX 3 Thu Apr 20, 2017 8:14 am
No new posts CICS Transaction Timeout Hooman24 CICS 2 Sun Apr 16, 2017 2:16 pm
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us