100
0
with Tags:
icetool
X
X
All posts
New DFSORT Functions
Yesterday DFSORT announced a new set of functions - as PTF UK90013. The documentation for it can be found here . Every year or so there's a new set of DFSORT functions - and generally they're "out of cycle" with z/OS releases - although they are incorporated into subsequent releases of z/OS. This means that fewer of you will know about the functions, particularly as we don't make a big fuss about... [More]
|
DFSORT Sorting Without Sorting Header / Trailer Lines
For whoever got to my blog with this Google search here's how you sort data without a header: First you need to be using z/OS DFSORT Release 10 or to have applied the PTFs for UK90013 (July 2008). Second, the vehicle for doing this is ICETOOL rather than DFSORT itself. Use the new DATASORT operator. Here's an example: If you code DATASORT FROM(DD1) TO(DD) FIRST(3) USING(CTL1) and code a CTL1CNTL... [More]
|
DFSORT Does JOIN
A new set of function was recently made available for DFSORT via PTFs UK51706 and UK51707. In this post I want to talk about the new JOINKEYS function, and try to add a little value by discussing some performance considerations. I've had the code for a couple of months and have played with it but not extensively. So much of what follows is based on thinking about the function (described in this... [More]
|
DFSORT - Now With Extra Magical Ingredients
Thanks to Scott Drummond for reminding me of last Autumn's DFSORT Function PTFs - UK90025 and UK90026. They're mentioned in the preview for z/OS Release 13 so now is not such a bad time to be talking about them. So let me pick out a few highlights: Translation Between ASCII And EBCDIC, And To And From Hex and Binary For a long time DFSORT has been able to translate to upper case (TRAN=LTOU), to... [More]
|
XML, XSLT and DFSORT, Part Zero - Overview
In the distant past I've written about using DFSORT to parse XML. This post (and two follow-on posts) will describe
an experiment to make such processing much more robust. In this post I'll talk about what the problem I'm trying to solve is. And why. And a brief outline of my solution. About XML This isn't meant to be the most detailed description of XML, nor a complete list of where it's used. I... [More]
|
XML, XSLT and DFSORT, Part Two - DFSORT
Following on from this post and this one , this post discusses the DFSORT piece. The DFSORT code in this post parses the Comma-Separated Variable (CSV) file produced by XSLT processing. In this simple example it merely produces a flat file report, but the post has a few additional details you might find valuable. First, here's the SORTIN DD JCL statement. It's not like a regular sequential file... [More]
|
