Syncsort to extract the records

shankarm · Active User Joined: 17 May 2010 Posts: 175 Location: India

Hi,

I have to extract the records with the below criteria.
1. The record should not have 'SUP' from the position 7(File is a VB file).
2. It should not contain the word <FSA> in the entire record.

My VB files LRECL is 32000.. Here is what i have tried....

shankarm · Active User Joined: 17 May 2010 Posts: 175 Location: India

Sorry this is what i tried.

Anuj Dhawan · Posted: Tue Apr 19, 2011 4:14 pm

If the condition 1 AND 2 are not mutally exclusive for your case -- you've to use "AND" instead of OR in your Sort-card.

If that's not the case, please tell us -- how it is not working? What do you get in the output, which makes you say, it's not working.

Anuj Dhawan · Posted: Tue Apr 19, 2011 4:15 pm

Well, did not see your reply until I hit "Submit" on my terminal. So, first observation in my previous post does not stand -- what do you get in output, which makes you say, it's not working.

shankarm · Active User Joined: 17 May 2010 Posts: 175 Location: India

Thanks for the response anuj.
This is the input i am using.....

Anuj Dhawan · Posted: Wed Apr 20, 2011 1:01 am

It looks you have got that all correct; however,

You have used "SS" and using 32,000 VB LRECL -- how about using VLSHRT? I assume, not all the records are of lenght 32,000.
If you are thinking about RDW then sort statemetns should be like =(5,....
RDW is of four bytes.
And are you sure, have you used the correct positions? As the sort statements does not have any syntax-error, however, there might be a logical error.

Bill Woodger · Posted: Wed Apr 20, 2011 2:40 am

11 doesn't look right as a start position for SUP, but that might just be the way it is displayed here. Check anyway.

As Anuj says, the Record Descriptor Word is, well, it's a word long (four bytes). So your first parameter should start with 5, not 4, although it should have no affect on the processing. So, the position of SUP looks wrong, and a valid-looking statement isn't working. Check. 4 for RDW, then however many until your field starts - it looks less than 11, anyway.

expat · Posted: Wed Apr 20, 2011 12:55 pm

Bill, 11 would be correct fo a VB input file as the sort products include the RDW whereas most other programs do not.

I checked the OP's positioning and the SUP is in pos 7 which is really pos 11 including the RDW.

Nic Clouston · Posted: Wed Apr 20, 2011 3:05 pm

Depends whether he is showing the RDW in the data shot. But it could be all application data.

Bill Woodger · Posted: Wed Apr 20, 2011 4:51 pm

It looks all messy when I look inside the "code" block. For some reason HEX and SCALE don't work on my browser.

I think the squirly bits of display are data, as otherwise the record-length has run into the IOCS, which it won't.

How about, I don't like suggesting, splitting in two just to find out which is working.

Also, check your JCL. I have known people to have DISP=(NEW,CATLG) and leaving uncatalogued datasets lying around with the latest data in, but they continually look at the catalogued one and can't understand why no changes take place. DISP=MOD might play similar tricks (I don't know specifically from a modern SORT).

shankarm · Active User Joined: 17 May 2010 Posts: 175 Location: India

I can assure you guys that SUP is in position 11 only. but still its not working.

Escapa · Posted: Wed Apr 20, 2011 7:26 pm

shankarm · Active User Joined: 17 May 2010 Posts: 175 Location: India

its a VB file.

Escapa · Posted: Wed Apr 20, 2011 7:36 pm

Bill Woodger · Posted: Wed Apr 20, 2011 10:07 pm

Hi Shan,

Any thoughts on my suggestion to submit the two parts of your condition seperately to find out if they are working? They will either both work individiually, or one will work, or the other will work, or neither will work. Whatever happens, we will have more information to work on.

sabarikanth · Posted: Thu Apr 21, 2011 4:45 am

Hi Shankar,

Hope this works.....
Please try and let us know.....

Bill Woodger · Posted: Thu Apr 21, 2011 5:02 am

Sab,

You've swapped the statements around. Are you suggesting that will fix the problem?

Why did you change the start positions? Starting at 1 will be looking at the entire record, including the RDW, so should be 5. And 15 will miss the value SUP for definite.

gcicchet · Posted: Thu Apr 21, 2011 7:33 am

Hi,

can you show the records with HEX ON and COLS.

Also the SYSOUT messages produced from job.

Gerry

sabarikanth · Posted: Fri Apr 22, 2011 3:39 am

Hi Bill,
But It fixed the problem.

Input:

Bill Woodger · Posted: Fri Apr 22, 2011 4:08 am

Hi Sab,

I was asking if you had swapped the conditions around because you were aware of a particular problem with coding them the other way.

Although your input file looks different, your parameters should help the TS to get somewhere as, as you say, one record has been deleted (I assume you have checked that it is the correct one).

The (1,32000... will start the search in the Record-length/IOCS (Record Descriptor Word/RDW) where you will not find C'<FSA>'. Later, someone looking at the code will wonder why you did that. It should be (5,32000... so that is starts instead in the data.

So, Shan, back to you if you haven't already fixed it. I'm thinking JCL...

sabarikanth · Posted: Fri Apr 22, 2011 4:19 am

Bill,

Bill Woodger · Posted: Fri Apr 22, 2011 4:43 am