View previous topic :: View next topic
|
Author |
Message |
sudhee_rb
New User
Joined: 29 Mar 2006 Posts: 34
|
|
|
|
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 |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007 Posts: 295 Location: Singapore
|
|
|
|
Hi,
I would rather suggest you to go for rexx. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
cpuhawg
Active User
Joined: 14 Jun 2006 Posts: 331 Location: Jacksonville, FL
|
|
|
|
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 |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
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 |
|
|
Help-Me-Out
New User
Joined: 09 Dec 2006 Posts: 56 Location: Pune
|
|
|
|
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 |
|
|
|