IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Sort to select only numeric fields


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Elixir

Active User


Joined: 08 Feb 2009
Posts: 116
Location: CHENNAI/NEW JERSEY - INDIA/USA

PostPosted: Thu Feb 12, 2009 12:54 pm
Reply with quote

Could any one let me know the sort card format to select only the numeric form of data.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19251
Location: Inside the Matrix

PostPosted: Thu Feb 12, 2009 8:43 pm
Reply with quote

Hello,

Post some sample data (real or invented) of what you "have" and what you want as output from that sample data.

Mention the relevant data positions as well as the recfm and lrecl of the data.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Thu Feb 12, 2009 10:34 pm
Reply with quote

Quote:
Could any one let me know the sort card format to select only the numeric form of data.


If you want to only include records that have numeric data in some field, you can do that with DFSORT's NUM function. See "Numeric and Non-Numeric Tests (NUM)" in my paper at:

Use [URL] BBCode for Links

If you want to do something else, you need to give complete details on what you want to do with an example.
Back to top
View user's profile Send private message
Elixir

Active User


Joined: 08 Feb 2009
Posts: 116
Location: CHENNAI/NEW JERSEY - INDIA/USA

PostPosted: Mon Feb 22, 2016 7:52 pm
Reply with quote

Sorry..been it's been a long while, I am unable access the link successfully, getting below error,

Our apologies…
The page you requested cannot be displayed
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Mon Feb 22, 2016 8:07 pm
Reply with quote

I hope you haven't been trying for the past 7 years. icon_smile.gif
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

PostPosted: Mon Feb 22, 2016 9:02 pm
Reply with quote

I've fixed the link.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts COBOL VS SORT Utility for file format... COBOL Programming 6
No new posts Copying data from prev record using SORT SYNCSORT 19
No new posts how to get total count from numeric d... SYNCSORT 9
No new posts Combining more 4 files with sorted or... DFSORT/ICETOOL 3
No new posts Break a record into fields, each fiel... SYNCSORT 2

Back to Top