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

Validation for numeric and non-nunmeric fields through job?


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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: 1436
Location: Bangalore,India

PostPosted: Mon Oct 15, 2007 12:40 pm
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: 1287
Location: Chennai, India

PostPosted: Mon Oct 15, 2007 12:43 pm
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: 1208
Location: Bangalore,India

PostPosted: Mon Oct 15, 2007 1:50 pm
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: 2146
Location: At my coffee table

PostPosted: Mon Oct 15, 2007 5:35 pm
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
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 Developer


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

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

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

Use [URL] BBCode for External Links
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Issues Converting From ZD to Signed N... DFSORT/ICETOOL 4
No new posts Convert HEX to Numeric DB2 3
No new posts Find a record count/numeric is multip... COBOL Programming 1
No new posts Concatenate 2 fields (usage national)... COBOL Programming 2
No new posts Cobol COMP-2 fields getting scrambled... Java & MQSeries 6
Search our Forums:

Back to Top