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
 

 

removing entire string frm a member.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
sudhee_rb

New User


Joined: 29 Mar 2006
Posts: 34

PostPosted: Wed Feb 27, 2008 4:22 pm    Post subject: removing entire string frm a member.
Reply with quote

Hi All,

1)I want to remove one entire string from 100 members,

can anybody please help me how to do using FILEAID BATCH.

2)and can we use copy and remove in same jcl?

Thanks in advance.
Back to top
View user's profile Send private message

Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Wed Feb 27, 2008 4:46 pm    Post subject:
Reply with quote

Hi,
I would rather suggest you to go for rexx.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Feb 27, 2008 11:14 pm    Post subject:
Reply with quote

Hello,

For us to be able to help, i'd suggest you post some sample data and how it should be after your process executes.

Strings would typically be changed. Please show how you want them "removed".

Once the requirement is better understood, someone may have a usable suggestion as to how you might do what you need.
Back to top
View user's profile Send private message
cpuhawg

Active User


Joined: 14 Jun 2006
Posts: 331
Location: Jacksonville, FL

PostPosted: Thu Feb 28, 2008 12:51 am    Post subject: Reply to: removing entire string frm a member.
Reply with quote

This setup should work for you using FILEAID.

Code:

//FILEAID EXEC PGM=FILEAID                       
//SYSPRINT DD  SYSOUT=*                         
//DD01     DD DSN=HLQ.INPUT.PDS,DISP=SHR         
//DD01O    DD DSN=HLQ.OUTPUT,DISP=SHR           
//SYSIN    DD  *                                 
$$DD01 COPY MEMBERS=ALL,                         
            IF=(35,NE,C'SEARCH INFO HERE')       
/*                                               


Select the position your data is in and code the information you are searching for. This JCL will copy all members from DD01 to DD01O. If it find a match to your exclusion data, that line in the PDS member will not be copied to the new file. Keep in mind the statistics related to the new PDS may not indicate the new number of records in any PDS member where lines were removed.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Thu Feb 28, 2008 3:56 am    Post subject:
Reply with quote

Hi,
if the string is not positional you can use the following :-

Code:
$$DD01 DROP MEMBERS=ALL,                           
            IF=(1,0,C'STRING INFO HERE')           


Gerry
Back to top
View user's profile Send private message
Help-Me-Out

New User


Joined: 09 Dec 2006
Posts: 56
Location: Pune

PostPosted: Thu Feb 28, 2008 12:12 pm    Post subject:
Reply with quote

Hi,

1)I want to remove one entire string from 100 members,

can anybody please help me how to do using FILEAID BATCH.

what you want to do with the string? do you want spaces out there or drop the record ehich has the string. above answer from gerry would drop the whole record which has the search string.

please clarify & provide some test data.
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 -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts What is the command to check MODE of ... rohanthengal CLIST & REXX 7 Fri Nov 18, 2016 1:48 pm
This topic is locked: you cannot edit posts or make replies. Checking wether a string starts from ... sundaram.naveen CLIST & REXX 9 Thu Oct 06, 2016 11:56 am
No new posts Removing Extra Spaces in a comma sepa... Puspojit DFSORT/ICETOOL 3 Tue Sep 13, 2016 7:46 am


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