Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Validation for numeric and non-nunmeric fields through job?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
sanjayis01
Warnings : 1

New User


Joined: 13 Jun 2007
Posts: 55
Location: banaglore

PostPosted: Mon Oct 15, 2007 12:39 pm    Post subject: Validation for numeric and non-nunmeric fields through job?
Reply with quote

Hi All


I want to validation for numeric fields and numeric fields using DFSORT

for example : Field1 having value 133B5, 13345
133b5 has to be filterd out

could you please post any solutions for this .
Back to top
View user's profile Send private message

murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Mon Oct 15, 2007 12:40 pm    Post subject:
Reply with quote

Sanjay,

This was discussed earlier. Search DFSORT forum.
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Mon Oct 15, 2007 12:43 pm    Post subject: Reply to: Validation for numeric and non-nunmeric fields thr
Reply with quote

Search this forum with the keyword NUM for similar topics.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Mon Oct 15, 2007 1:50 pm    Post subject:
Reply with quote

Hi There,

Please use following sort card

Code:

  SORT FIELDS=COPY             
  INCLUDE COND=(1,5,FS,EQ,NUM)
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Mon Oct 15, 2007 5:35 pm    Post subject: Re: Validation for numeric and non-nunmeric fields through j
Reply with quote

sanjayis01 wrote:
for example : Field1 having value 133B5, 13345
133b5 has to be filterd out
Why is the 13345 being filtered out?
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Mon Oct 15, 2007 6:14 pm    Post subject:
Reply with quote

CICS Guy
sanjay is poiting at 133b5 to be filtered out, not 13345.

sanjay, look at the follwoing thread, this may be helpful
http://ibmmainframes.com/viewtopic.php?t=24380&highlight=numeric
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Mon Oct 15, 2007 9:58 pm    Post subject:
Reply with quote

For more information on DFSORT's NUM function which has been available since April, 2006, see:

www.ibm.com/servers/storage/support/software/sort/mvs/peug/
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORT BUT RETAIN HIGHEST VALUE ON NON-... leondan22 DFSORT/ICETOOL 2 Thu Dec 14, 2017 8:13 pm
No new posts Moving a COMP-3 Variable to a Numeric... ajayachander COBOL Programming 2 Thu Dec 14, 2017 5:46 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am
No new posts Subtract the ZD fields to provide neg... Balaryan DFSORT/ICETOOL 4 Wed Oct 11, 2017 10:51 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us