Posted: Tue Jul 03, 2007 6:39 am Post subject: select records where timestamp matches current year
I have a file with FB and LRECL=2562. I have a timestamp starting at position 1891. I would like to select only timestamp which matches the
current year from this file and write to another file.
At the moment I do it like this, with the year hard coded. Is it possible
to say for example CURRENT YEAR instead of hard coding?
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Tue Jul 03, 2007 10:10 am Post subject:
Here's a better way to do it using DFSORT's new System Symbol String Constants (S'string') feature. You'll need z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006) to use this new feature. 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:
_________________ 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
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