To delete only few records from flat file

kumar1234 · New User Joined: 06 Nov 2007 Posts: 84 Location: bangalore

Hi,

I have a flat file where I want delete only the 3rd and the 6th record. Could anyone please let me know the JCL which I nned to use to perform this task. I am not supposed to delete it manually. I need to delete based on the first 9 bytes key.

Below are the records'

Pandora-Box · Posted: Thu Nov 29, 2012 12:46 pm

Delete is equal to OMIT

So OMIT those records using SORT for the specific keys

kumar1234 · New User Joined: 06 Nov 2007 Posts: 84 Location: bangalore

Could you please give the syntax for it.

Thanks.

Bill Woodger · Posted: Thu Nov 29, 2012 12:57 pm

It seems to be a strange type of requirement. Is it for learning?

If you use OMIT/INCLUDE for your two key values, you can certainly get rid of the 3rd and 6th records, but bear in mind that anywhere else in the data that the same key exists will also be rermoved.

You could get rid of 3rd, and 6th, blindly, by generating a SEQNUM (sequence number) and using OUTFIL OMIT/INCLUDE.

To get rid of 3rd and 6th with particular keys, combine the two on OUTFIL OMIT/INCLUDE.

Pandora-Box · Posted: Thu Nov 29, 2012 1:02 pm

INCLUDE COND includes the records and OMIT COND omits the records

I see your old posts and you have prior experince with INCLUDE COND

Can't you try this yourself?

Nic Clouston · Posted: Thu Nov 29, 2012 4:51 pm

Phrzby Phil · Posted: Thu Nov 29, 2012 6:36 pm

I presume you know that you are actually deleting the records from a copy of the file - the input flat file will be untouched.

dick scherrer · Posted: Thu Nov 29, 2012 9:50 pm

Hello,

And NO, you should NOT try to write the output back over the original input data. . .