Smart DFSORT Tricks - IBM

← Back to document page

Smart DFSORT TricksOctober, 2010DFSORT Web SiteFor papers, online books, news, tips, examples and more, visit the DFSORT website at URL: iiSmart DFSORT Tricks ContentsSmart DFSORT Tricks1Introduction: Details of functions used in tricks1Introduction: PTF level of functions needed for tricks1Update count and total in existing trailer2Create large records from small records4Create small records from large records5Convert between different types of dates6Identify invalid dates8Extract corresponding weekdays from dates9Add/subract days, months, years for date fields10Calculating days between two date fields11Using SET and PROC symbols in control statements11Limit i

You can use the RESIZE operator of DFSORT's ICETOOL to create one long fixed-length record from several shorter fixed-length records. Let's say we have an input file with RECFM=FB and LRECL=10 that has these records: Record 001 Record 002 Record 003 Record 004 Record 005 Record 006 Record 007 Record 008 We want to combine three records into one.

  Into, Into one