To Omit records using file-aid

mf_karthik · New User Joined: 26 Jul 2005 Posts: 55

hi all,
i am using a file-aid in a jcl to copy from one dataset to other dataset,i'm using $$dd01 copy.

there are some invalid records in the input file,i want to omit that records while copying

ex: y00000000000
i want to remove this record..

what is the command in file-aid to omit this records.

Anuj Dhawan · Posted: Tue Sep 09, 2008 11:25 pm

Hi,

Would suggest you to show a little more complete example of your input & output. Show some sample input data & what is expected output from that - what should be there in output & what should not be. If possible, please tell us how do you want to eliminate some record or as other would ask the rules to copy records.

When you post the input/output record details, please use BBcode.

mf_karthik · New User Joined: 26 Jul 2005 Posts: 55

hi,

here is my input and expected output.

input:

gcicchet · Posted: Wed Sep 10, 2008 1:52 pm

Hi,

try this

mf_karthik · New User Joined: 26 Jul 2005 Posts: 55

Hi Gerry,

Thanks for your reply..please explain me the syntax ie the purpose of OUT=0

I have searched but in vain.

gcicchet · Posted: Tue Sep 23, 2008 3:28 pm

Hi,

if you do not specify OUT=0 it defaults to max of 999999 records to be written IFRC.

OUT=0 overrides the deafult or nullifies the default to unlimited.

Gerry

gcicchet · Posted: Tue Sep 23, 2008 3:49 pm

Hi,

The OUT=0 parameter processes the entire file. no OUT parameter defaults to 999999999, which is a fairly high number but still not necessarily the entire file.

Gerry