Syncsort - can we move particular records to an output file

sakrish · New User Joined: 05 Nov 2008 Posts: 18 Location: chennai

Can someone tell can we move only paritcular records in a file to output

I have 50 records out of which I want to move from 3rd record to 10 th record and 25th record to 40th record into an output file.

gcicchet · Senior Member Joined: 28 Jul 2006 Posts: 691

Hi,

try this

expat · Posted: Thu Nov 06, 2008 3:31 pm Post subject:

Thanks Gerry, that's another one for me to squirrel away

enrico-sorichetti

but if You have the proper DFSORT ptf' s, You could use the new subset operator

SUBSET .... RRN(3,10) RRN(25,40)

search the DFSORT forum for SUBSET

Frank Yaeger · Posted: Thu Nov 06, 2008 10:34 pm Post subject:

sakrish,

You can do that quite easily using the new SUBSET operator of DFSORT's ICETOOL available with z/OS DFSORT V1R5 PTF UK90013 (July, 2008). For example:

sakrish · New User Joined: 05 Nov 2008 Posts: 18 Location: chennai

Thanks a lot guys..

I am new to ICETOOLS

when I ran the JCL,

gcicchet · Senior Member Joined: 28 Jul 2006 Posts: 691

Hi,

from the messages you have shown, it looks like you are NOT using DFSORT/ICETOOL

Gerry

dick scherrer · Posted: Fri Nov 07, 2008 9:06 am Post subject:

Hello,

You are running Syncsort rather than DFSORT.

Suggest you try with earlier code Gerry posted as the new DFSORT SUBSET operator is only available with DFSORT.

gcicchet · Senior Member Joined: 28 Jul 2006 Posts: 691

Hi Dick,

even having DFSORT doesn't help.

My version of DFSORT is ancient and not likely to change.

Below is my version of DFSORT.

ICE201I 0 RECORD TYPE ...

the 0 indicates you do not have the July, 2008 or April, 2006 DFSORT functions. You are way behind on DFSORT functional PTFs. Ask your System Programmer to install z/OS DFSORT PTF UK90013.

You may or may not have the Dec, 2004 DFSORT functions (IFTHEN, OVERLAY, SFF, UFF, etc), which corresponds to z/OS DFSORT V1R5 PTF UQ95214. try using one of these functions - if you get errors trying to use it, then you don't even have the Dec, 2004 PTF installed.

Gerry

dick scherrer · Posted: Fri Nov 07, 2008 9:28 am Post subject:

Hi Gerry,

No, but Sai is using Syncsort and if that product is even a little bit current on their system, the ifthen should work. . .

IFTHEN & OVERLAY became available in Syncsort 1.2.x iirc.

gcicchet · Senior Member Joined: 28 Jul 2006 Posts: 691

Hi Dick,

I was just having a private whinge about the version of DFSORT in my shop and it's very difficult to get it upgraded.

Gerry

dick scherrer

Hi Gerry,

Frank Yaeger · Posted: Fri Nov 07, 2008 9:35 pm Post subject:

Gerry,

I assume you realize that the upgrade "problem" is a problem with your shop, not with DFSORT. In fact, we ship the new functions as PTFs to make them easier to install. I don't know why your shop chooses not to install PTFs, but that's not generally the way shops operate.

gcicchet · Senior Member Joined: 28 Jul 2006 Posts: 691

Hi Frank,

I totally agree with you, it has nothing to do with DFSORT, as you can see from the earlier message my version of DFSORT is lagging behind.

I better not say anymore.

Gerry

Aaru

Frank,