Need the sort card using Build option.

mfchnuser · New User Joined: 21 Sep 2012 Posts: 12 Location: India

Hi

I have a file which has the record in this order in FILE A

Incident number(10) Ind1(1) Ind2(1)

the possible values of Ind 1 and Ind 2 are P,G and A,B respectively

eg-

Bill Woodger · Posted: Mon Dec 10, 2012 5:40 pm

Please note that your post has been Code'd to preserve the spacing.

Can you show sample data, RECFM and LRECL, for both input files, and expected output from that, with matches, not matches, whatever. I think you are better looking at JOINKEYS, but can't be certain until we see what you want.

mfchnuser · New User Joined: 21 Sep 2012 Posts: 12 Location: India

The requirement is as follows:

There are 3 files

FILE A( FB nad LRECL 80)
FILE B( FB nad LRECL 200)
FILE C( FB nad LRECL 200)

File A contents are -

0000000091 P A
0000000091 G A
0000000072 P B
0000000051 G B

these are the meanings of indicators-

A and B indicate whether record need to be omitted from FILE B or FILE C

P-(type 1 incident),G(Type 2 incident) so P and G are types of incidents

if an incident no. is given with a P in file 1 , then the incident number is at pos 20 in FILEB or FILEC

if an incident no. is given with a G in file 1 , then the incident number is at pos 40 in FILEB or FILE C

So, based on these indicators i need omit sort condition to delete records from the 2 files FILE B and FILE C

Thanks in advance for your help

Garry Carroll · Posted: Mon Dec 10, 2012 6:22 pm

mfchnuser · New User Joined: 21 Sep 2012 Posts: 12 Location: India

A and B simply indicate whether records for a particular incident number needs to be deleted from FILE B or FILE C

both FILE B and FILE C have exactly same records initially.

dick scherrer · Posted: Mon Dec 10, 2012 8:20 pm

Hello,

You need to post both of the input files sample data and the output you want from that sample data. Make the samples comprehensive.

USE the Code tag for readability. Use the Preview to see how your post will apear to the forum.

Completely / clearly re-post your "rules".

Skolusu · Posted: Mon Dec 10, 2012 10:34 pm

mfchnuser,

What is the final output? Records from both FILEB and FILEC after the elimination into a single file? or do they need to be split accordingly ?

Run the following job and show us the complete sysout which helps us to determine the level of DFSORT your system has

mfchnuser · New User Joined: 21 Sep 2012 Posts: 12 Location: India

ran the job you gave earlier

the sysout is as follows:

Bill Woodger · Posted: Tue Dec 11, 2012 5:16 pm

WER messages mean you have SynsSort, so posted in the wrong forum. SyncSort questions go in JCL.

Kolusu is a DFSORT developer. SyncSort is a competitor product, and you have now wasted Kolusu's time.

Please ensure you don't post in the wrong forum again.

Garry Carroll · Posted: Tue Dec 11, 2012 5:21 pm

Your output shows you are using SYNCSORT, not DFSORT. You have posted in the wrong forum - you should be in the JCL forum which is for both JCL and SYNCSORT.

Also, you have now changed from using A and B indicators to B and C indicators and these now appear to indicate from which of the files the records are to be removed. I asked for clarification on this yesterday but your response to that request did not clarify.

Garry.

daveporcelan · Posted: Tue Dec 11, 2012 7:01 pm

I think as though you are over complicating this with Files B and C and the 'delete from' approach.

Try to redefine your requirements with just two input files 1 and 2 (since B and C are the same anyway).

You can then use a combination of Cond and Joinkeys (with unpaired 2) to select the ones you want from file 2 to go to output file 1 and the ones you want to go output file 2.

This positive logic is much easier for the human mind to process (at least my mind).

mfchnuser · New User Joined: 21 Sep 2012 Posts: 12 Location: India

Gary, sorry for posting this in DFSORT , i will repost in syncsort, i made indicators as B and C to make it sound easy , so that indicators match the file name

daveporcelan, these files B and C are not completely same, however many records are same. the records which i need to delete using sort card will exist in both files but that does not mean files are same. I just gave sample data as asked

Bill Woodger · Posted: Wed Dec 12, 2012 5:34 pm

mfchnuser · New User Joined: 21 Sep 2012 Posts: 12 Location: India

Thanks Bill for moving this to correct forum, It would be great if someoe can help me with this.

Thanks in advance

Bill Woodger · Posted: Wed Dec 12, 2012 6:03 pm

Can you show the input and output files for the code that you were given, please?

mfchnuser · New User Joined: 21 Sep 2012 Posts: 12 Location: India

Input files:

FILE A

daveporcelan · Posted: Wed Dec 12, 2012 7:10 pm

How many records are in each of these files?

The reason I ask is that an alternate approach (Rexx maybe) may be in order.

From my observation, a multiple pass Syncsort solution would be required.

You would need at least one step to Joinkeys on A and B and and another to Joinkeys A and C. There may even be two for each because the key in B and C varies based on the P/G value in A.

Not an easy one is it?

Bill Woodger · Posted: Wed Dec 12, 2012 7:39 pm

mfchnuser · New User Joined: 21 Sep 2012 Posts: 12 Location: India

Hi daveporcelan

The number of records vary from day to day load..it might go upto 50 k.

Rexx cant be used as this step has to be added as part of existing JCL.

Bill, since this will be a dynamic sort card since the FILE A contents will change daily. I was looking for what can be given using build statement

daveporcelan · Posted: Wed Dec 12, 2012 8:09 pm

Bill Woodger · Posted: Wed Dec 12, 2012 8:15 pm

I was providing an OMIT that I thought you could then generate...

However...

As you do not know the P/G, except on FILE A, I don't think ANY single OMIT is going to do what you want (as you show in your data, that an incident number could be in either place on FILE B or C).

I think you would need to pass each of the two files twice, with different OMITs.

It is either that or "program time", or try to work out what Kolusu had in mind :-), bearing in mind also that there are things like JNFnCNTL files which DFSORT has and your SyncSort may not.

Anbarasan D · New User Joined: 20 Apr 2010 Posts: 21 Location: USA

You can try this.

Bill Woodger · Posted: Thu Dec 13, 2012 1:31 am

Mmmm.... are you sure that that is going to satisfy the requirement?

How are you distinguishing between TS's FILEB and FILEC for your, er, one final output file?

Anbarasan D · New User Joined: 20 Apr 2010 Posts: 21 Location: USA

Sorry, I coded only for one output file(FILEB). Need to have the third step to get the output for FILEC(similar like S2 step)

daveporcelan · Posted: Thu Dec 13, 2012 1:52 am

I think you also need the output from step S2 to be reprocessed a second time to ensure it doesn't match Type G with File B.

I see this is many sort steps before your done.

Or one small Rexx program.

I think we have lost the TS however. Maybe wait to see if they are still with us.