View previous topic :: View next topic
|
Author |
Message |
akashs
New User
Joined: 24 Nov 2005 Posts: 49 Location: chennai
|
|
|
|
Hi,
I need to remove invalid records from my input file.My input file is of length VB 2048.For some records, Field in position 41 to 43 is populated with Junk values.It is comp-3 field.Please suggest me a way to remove those records from my input file.
I dont have PGM=FILEAID utility in my shop.
regards,
Akash |
|
Back to top |
|
|
Ketan Varhade
Active User
Joined: 29 Jun 2009 Posts: 197 Location: Mumbai
|
|
|
|
If you know the possible values that this position can cantian you can filter the file, else
give more details on the fields that you need to check |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Define Junk values !
What you deem as junk can be perfectly valid for another forum member.
Had you have looked at ways to do this yourself in the forum, there are many many excellent examples of using your sort product to do this. Matching records from two files perhaps, or maybe using INCLUDE / OMIT conditions.
And if, as I suspect, you ask for a sort solution, please find out which sort product is used at your site and tell us before someone else wastes their valuable time coding and testing something that will not work with the sort product that you use. |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
Quote: |
...Field in position 41 to 43 is populated with Junk values.It is comp-3 field. |
How dare you call my beloved COMP-3 data "junk". |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Akash,
If by junk values, you mean non-numeric PD values, you can use DFSORT control statements like this:
Code: |
OPTION COPY
OMIT COND=(p,3,PD,NE,NUM)
|
Use 41 for p if that includes the RDW in positions 1-4. Otherwise, use 45 for p. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Quote: |
Quote: |
...Field in position 41 to 43 is populated with Junk values.It is comp-3 field. |
How dare you call my beloved COMP-3 data "junk". |
"Sign Sign everywhere a sign
Blocking out the scenery breaking my mind
Do this, don't do that, can't you read the sign"
For those of a certain (or older) age. . .
d |
|
Back to top |
|
|
akashs
New User
Joined: 24 Nov 2005 Posts: 49 Location: chennai
|
|
|
|
Hi,
Thank u very much frank..
regards,
Akash |
|
Back to top |
|
|
|