IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

removing entire string frm a member.


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
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
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
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

Moderator Emeritus


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

PostPosted: Wed Feb 27, 2008 11:14 pm
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
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: 1702
Location: Australia

PostPosted: Thu Feb 28, 2008 3:56 am
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts Replace each space in cobol string wi... COBOL Programming 3
No new posts PARSE Syntax for not fix length word ... JCL & VSAM 7
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
No new posts file manager is doing string conversion IBM Tools 3
No new posts How to copy the -1 version of a membe... TSO/ISPF 4
Search our Forums:

Back to Top