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
 
How to delete records when we have partial key

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
sajjan jindal
Warnings : 1

New User


Joined: 09 Sep 2007
Posts: 60
Location: india

PostPosted: Sat Aug 01, 2009 11:02 pm    Post subject: How to delete records when we have partial key
Reply with quote

How to delete records when we have partial key:
suppose the key is

NY001
NY002
NY003
'
'
'
NY099

I want to delete all the records with the partial key NY.
WHere will we get the number of records deleted??
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: Sat Aug 01, 2009 11:12 pm    Post subject:
Reply with quote

There is a link to the manuals at the top of the page. Click on it, find the CICS Language Reference manual, and read up on the DELETE command. You should be able to find what you need there.
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: Sat Aug 01, 2009 11:15 pm    Post subject: Reply to: How to delete records when we have partial key
Reply with quote

In addition to the normal keywords for this API, you're going to need to specify the KEYLENGTH and GENERIC keywords for partial key DELETE's.

After issuing this API command, keyword NUMRECS will contain the number of records deleted.

Please review your version/release of the applicable CICS "Application Program Reference", where this is clearly documented.

Book Manager ===> http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/library

Bill
Back to top
View user's profile Send private message
sajjan jindal
Warnings : 1

New User


Joined: 09 Sep 2007
Posts: 60
Location: india

PostPosted: Sun Aug 02, 2009 12:04 am    Post subject:
Reply with quote

He He, thanks dear

following is the answer :

The following example shows how to delete a group of records in a file:

EXEC CICS DELETE
FILE('MASTFILE')
RIDFLD(ACCTNO)
KEYLENGTH(4)
GENERIC
NUMREC(NUMDEL)


NUMREC(data-area)
Specifies a 16-bit binary field that is to receive the number of records that have been deleted.

refer the following link:

http://publib.boulder.ibm.com/infocenter/txformp/v6r0m0/index.jsp?topic=/com.ibm.cics.te.doc/erziai0033.htm

NUMREC(data-area)
Specifies a 16-bit binary field that is to receive the number of records that have been 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: Sun Aug 02, 2009 1:27 am    Post subject: Reply to: How to delete records when we have partial key
Reply with quote

Are you on any type of medication or lack thereof?

What's with the "He He, thanks dear"?
Back to top
View user's profile Send private message
sajjan jindal
Warnings : 1

New User


Joined: 09 Sep 2007
Posts: 60
Location: india

PostPosted: Sun Aug 02, 2009 6:42 am    Post subject:
Reply with quote

Hi Bill,

I apologise if you are offended.
icon_cry.gif

It was just to show my happiness for your help.

Regards,
Sajjan Jindal
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: Sun Aug 02, 2009 6:47 am    Post subject: Reply to: How to delete records when we have partial key
Reply with quote

I wasn't offended at all. It just seemed a little "kooky". icon_wink.gif

No Problem....

Bill
Back to top
View user's profile Send private message
Earl Haigh

Active User


Joined: 25 Jul 2006
Posts: 475

PostPosted: Sun Aug 02, 2009 8:14 am    Post subject:
Reply with quote

Bill,

You right, looks kooky to me also. First time I have seen someone
called Dear on a technical forum.

icon_lol.gif

Earl
Back to top
View user's profile Send private message
sajjan jindal
Warnings : 1

New User


Joined: 09 Sep 2007
Posts: 60
Location: india

PostPosted: Sun Aug 02, 2009 9:50 am    Post subject:
Reply with quote

If we go technical, does it mean we should loose the Human touch.
We are basically humans made of emotions, its a different issue that we are becoming more of automatons. isn't it?

Regards,
Sajjan Jindal.
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 Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 21 Sun Aug 27, 2017 10:35 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 Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am

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