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
 
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: 8154
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: 2504
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 exec macro in the end of edit anatol CLIST & REXX 8 Fri Sep 22, 2017 5:10 am
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm
No new posts Julian Date to CICS ABSTTIME blayek CICS 3 Wed Aug 30, 2017 11:15 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm
No new posts Delete IMS remote transaction when MO... Sam Singh IMS DB/DC 0 Wed Aug 23, 2017 9:12 pm

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