| | You can obtain DFSORT symbol mappings and sample jobs created by IBM for data associated with RACF, DFSMSrmm and DCOLLECT. - The RACFICE2 homepage has instructions for downloading RACFICE2 which contains the RACF symbol mappings.
- The DFSMSrmm symbol mappings are available in SYS1.MACLIB after SMP/E APPLY processing, as members EDGACTSY, EDGEXTSY, and EDGSMFSY.
| Back to top | The following papers can help programmers be more productive with DFSORT/ICETOOL. These papers can be downloaded as indicated below. | | z/OS DFSORT V1R10 PTF UK90025 and z/OS DFSORT V1R12 PTF UK90026, first available in October, 2010, provide important enhancements to DFSORT and DFSORT's ICETOOL for for resizing records (RESIZE operator); updating the trailer record (IFTRAIL); processing subsets (ACCEPT); translation of ASCII to EBCDIC (TRAN=ATOE), EBCDIC to ASCII (TRAN=ETOA), EBCDIC hex to binary (TRAN=UNHEX), and more; date field arithmetic (ADDDAYS, ADDMONS, ADDYEARS, SUBDAYS, SUBMONS, SUBYEARS, DATEDIFF, NEXTDday, PREVDday, LASTDAYW, LASTDAYM, LASTDAYQ and LASTDAYY); timestamp constant with microseconds (DATE5); group functions (KEYBEGIN); use of SET and PROC symbols in control statements (JPn"string" in EXEC PARM); more information in reports; larger fields; easier migration from other sort products, and more. SORTUGPH is the documentation for PTFs UK90025 and UK90026. It highlights, describes and shows examples of the new features provided by this PTF for DFSORT and for DFSORT's powerful, multi-purpose ICETOOL utility. It also details new and changed messages associated with this PTF. Note: This paper provides the documentation you need to start using the features and messages associated with z/OS DFSORT V1R10 PTF UK90025 and z/OS DFSORT V1R12 PTF UK90026. The information in this paper will be included in the latest z/OS DFSORT book at its next major update. | | z/OS DFSORT V1R5 PTF UK51706 and z/OS DFSORT V1R10 PTF UK51707, first available in November, 2009, provide important enhancements to DFSORT and DFSORT's ICETOOL for various types of two file join applications (JOINKEYS, JOIN, REFORMAT, JKFROM); date field conversions (Y2x, Y4x, TOJUL, TOGREG, WEEKDAY, DT, DTNS); merge operations (MERGE operator); alternate ddnames for merge files (MERGEIN); easier migration from other sort products, and more. SORTUGPG is the documentation for PTFs UK51706 and UK51707. It highlights, describes and shows examples of the new features provided by this PTF for DFSORT and for DFSORT's powerful, multi-purpose ICETOOL utility. It also details new and changed messages associated with this PTF. | | Download a pdf version of SORTUGPG (137KB) |
| | | Over the years, DFSORT has provided important enhancements in many areas. SORTNEW provides a quick introduction to selected DFSORT and ICETOOL enhancements available as of October, 2010. Examples using the various features are included, where appropriate. |
| | | | SORTBYND highlights and shows examples of some of the features of DFSORT that can improve application performance and programmer productivity. Topics included are: JOINKEYS, ICEGENER, multiple output, ICETOOL, INCLUDE/OMIT tests, reformatting features, OUTFIL features, SMF, TOD and ETOD date and time formats, floating sign format, free form formats, product connections, Symbols, National Language Support, Time-of-day controls, continue or terminate controls, SAS booster, BLDINDEX, Year 2000 features, and sources of information. SORTBYND reflects DFSORT features available as of October, 2010. | |
| | | | SORTTOOL is a mini-user guide for DFSORT's versatile ICETOOL data processing and reporting utility. The major features of ICETOOL, including its JCL and control statements, are discussed at length using many examples. The objective is to show you how to use ICETOOL to accomplish complex tasks. | |
| | | | | | Effective security management requires flexible analysis and reporting tools. With OS/390 Version 2 Release 8, RACF introduced the RACFICE reports in 'SYS1.SAMPLIB(IRRICE)'. RACFICE used DFSORT's ICETOOL to create a set of 30+ reports based on the output of the RACF Database Unload Utility (IRRDBU00) and the RACF SMF Unload Utility (IRRADU00). Since then, there have been several major enhancements to DFSORT. This package, RACFICE2, demonstrates how those enhancements can be used to do even more with the output of IRRDBU00 and IRRADU00. In addition, the RACFICE2 package contains a set of DFSORT Symbols that define the IRRDBU00 and IRRADU00 fields as documented in the "RACF Macros and Interfaces (SA22-7682)". The RACFICE2 home page has instructions for downloading RACFICE2. |
| | z/OS DFSORT V1R5 PTF UK90013, first available in July, 2008, provides important enhancements to DFSORT and DFSORT's ICETOOL for find and replace (FINDREP), group operations (WHEN=GROUP); sorting data between headers and trailers (DATASORT); keeping or removing the first n records, last n records and/or specific relative records (SUBSET); selecting the first n duplicate records (SELECT with FIRST(n) and FIRSTDUP(n)); splicing with non-blank fields (SPLICE with WITHANY); displaying and writing counts (DISPLAY with COUNT, EDCOUNT, BCOUNT and EDBCOUNT, and COUNT with ADD, SUB, WRITE, TEXT, DIGITS, EDCOUNT and WIDTH); reports with multiple and multipart titles (DISPLAY and OCCUR with TITLE, TLEFT and TFIRST); reports without carriage control characters (DISPLAY and OCCUR with NOCC); additional defaults (BLKSIZE for DUMMY, SKIP=0L for SECTIONS, and SORTOUT=ddname for FNAMES); easier migration from other sort products, and more. SORTUGPF is the documentation for PTF UK90013. It highlights, describes and shows examples of the new features provided by this PTF for DFSORT and for DFSORT's powerful, multi-purpose ICETOOL utility. It also details new and changed messages associated with this PTF. |
| | | | z/OS DFSORT V1R5 PTF UK90007 and DFSORT Release 14 PTF UK90006, first available in April, 2006, provide important enhancements to DFSORT and DFSORT's ICETOOL for extracting variable position/length fields (e.g. CSV, delimited fields, keyword separated fields, etc) into fixed parsed fields; justifying and squeezing data); comparing and inserting past and future date constants; testing for numerics and non-numerics; displaying hexadecimal floating-point values as integers; splitting files contiguously; suppressing page ejects in reports; using symbols for output columns; using system symbols (e.g. &SYSPLEX) in symbol constants; reformatting records before selecting or splicing; sorting and merging with larger PD and ZD fields; easier migration from other sort products, and more. SORTPEUG is the documentation for PTFs UK90007 and UK90006. It highlights, describes and shows examples of the new features provided by these PTFs for DFSORT and for DFSORT's powerful, multi-purpose ICETOOL utility. It also details new and changed messages associated with these PTFs. |
| | | | z/OS DFSORT V1R5 PTF UQ95214 and DFSORT Release 14 PTF UQ95213, first available in December, 2004, provide important enhancements to DFSORT and DFSORT's ICETOOL for conditionally reformatting records; overlaying only selected parts of records; larger numeric fields and constants; new data formats for extracting digits, and displaying TOD and ETOD date and time values; restarting sequence numbers; join and match operations; date and time constants; conversion of statistical and count values; reports; easier migration from other sort products, and more. SORTPDUG is the documentation for PTFs UQ95214 and UQ95213. It highlights, describes and shows examples of the new features provided by these PTFs for DFSORT and for DFSORT's powerful, multi-purpose ICETOOL utility. It also details new and changed messages associated with these PTFs. |
| | DFSORT Release 14 PTF UQ90053, first available in February, 2003 and incorporated into z/OS DFSORT V1R5, provides important enhancements for join and match operations, sampling, repeating and distributing records, arithmetic operations using numeric fields and decimal constants, longer fields for substring searches, easier migration from other sort products, and more. SORTPAUG is the documentation for PTF UQ90053. It highlights, describes and shows examples of the new features provided by PTF UQ90053 for DFSORT and for DFSORT's powerful, multi-purpose ICETOOL utility. It also details changed messages associated with this PTF. | |
| | | | DFSORT has Year 2000 features you can use to sort, merge, compare and transform a wide variety of dates with two-digit years according to a specified sliding or fixed century window. DFSORT's new generation of Year 2000 features handles "full dates" like yyq, yymm, yyddd, yymmdd, qyy, mmyy, dddyy and mmddyy and their special indicators. SORT2000 contains a detailed discussion of DFSORT's Year 2000 features and examples of the control statements needed to order, compare and transform all kinds of character, zoned decimal and packed decimal date fields. |
| |
|