Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Tue Sep 19, 2006 6:02 pm Post subject:
Here's a DFSORT/ICETOOL job that will do what you asked for. I assumed your input file has RECFM=FB and LRECL=80, but the job can be changed appropriately for other attributes.
You'll need z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006) in order to use DFSORT's INREC with SPLICE function. If you don't have the April, 2006 PTF, ask your System Programmer to install it (it's free). For complete details on all of the new DFSORT and ICETOOL functions available with the April, 2006 PTF, see:
If you see 'ICE201I E' in DFSMSG, you have the April, 2006 PTF. If you see 'ICE201I 0' in DFSMSG, you don't have the PTF. Without the PTF, you won't get any output records.
_________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Wed Sep 20, 2006 10:26 am Post subject:
With a VB file, we need to put the indicator and sequence number after the RDW rather than at the end of the record. Here's a modified DFSORT/ICETOOL job to do that. I assumed your input file has LRECL=80. For other LRECLs, just change WITH(6,89) to WITH(6,n) where n is LRECL+9.
_________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Hi Kolusu,
We had the new version of SYNCSORT (1.2.1.1N) where the IFTHEN function is working(I tried with a simple example).When I tried to execute the above code,I am getting the error like below.
WER186I SVC 109 IS INCORRECT VERSION OR NON-SYNCSORT - SVC NOT USED
Is there any difference in the CODING of the IFTHEN clause in SYNCSORT ?
Thank you _________________ ----------------
Thanks&Regards
Bprasanna
Joined: 26 Nov 2002 Posts: 12380 Topics: 75 Location: San Jose
Posted: Wed Sep 27, 2006 7:18 am Post subject:
bprasanna,
The solutions posted by Frank both use INREC processing for SPLICE which is new feature for ICETOOL. It is a part of the PTF UK90007 for z/OS DFSORT V1R5 and PTF UK90006 for DFSORT R14 (April, 2006) which has not been copied/implemented by Syncsort.
But that does not explain as to why you got that error. Your job should have abended with S0C4 as Splice from syncsort does not recongnise the INREC statement and validation on the ZD field fails resulting in S0C4. This is the information I got from looking up the message WER186I
Code:
WER186I SVC nnn IS INCORRECT VERSION OR NON-SYNCSORT - SVC NOT USED -
INEFFICIENT SORT
EXPLANATION: The SVC did not return a code indicating it was at
the correct version level, therefore it was not used. The SVC is
either at the wrong SyncSort release/maintenance level or is not
a SyncSort SVC. The problem could cause less efficient I/O and/or loss
of SMF records. ACTION: Notify your system programmer, who should
check that the SVC has been installed in the system libraries,
has been IPLed into the system, was specified via SYNCMAC, and
was not incorrectly overridden via $ORTPARM or the PARM field.
May be you need to call your systems programmer as I suspect that the alias for ICETOOL is not installed properly on your system.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
