Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Validate if a Value from the file is ... balacsv2 COBOL Programming 8 Mon Jun 19, 2017 11:52 pm
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm
No new posts Sum Fields ballaswaroop DFSORT/ICETOOL 4 Tue May 02, 2017 11:07 am
No new posts DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us