IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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: 19244
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:

ftp.software.ibm.com/storage/dfsort/mvs/sortpeug.pdf

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: 7309
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

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 7
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
No new posts how to calculate SUM for VB file usin... JCL & VSAM 1
Search our Forums:

Back to Top