Joined: 02 Dec 2003 Posts: 151 Location: Tokyo, Japan
Though it is tedious process...I can use INCLUDE condition as below to select Numeric items and omits nonnumeric items -
This rather involved INCLUDE statement keeps only
Joined: 06 Jan 2004 Posts: 247 Location: Hyderabad
i tried with your omit condition.but it didn't work for me.Actually the variable is packed decimal of 17 character length.somehow iam getting spaces in that field and also some values like 0402634517543.tif. so while sorting i thought of removing these kind of records.i tried many ways. sandip suggested some thing using include cond.but that one is very tedious one,which i cant use.
But there is another alternative for me.I skipped those records while reading that file in the program.So my problem is solved.
Just curious.Is there any other alternative thru omit condition to remove non numeric items.For removal of blank line i can give.but for .tif value what can i give.
With z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006), you can use DFSORT's new NUM function to include or omit records based on whether they contain character, packed decimal or zoned decimal numerics or non-numerics. For your example of a 17-byte PD field, you can use this INCLUDE statement (p is the starting position of the PD field):
or this OMIT statement:
For complete details of all of the new DFSORT/ICETOOL functions available with the April, 2006 PTFs, see: