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

To check if data is numeric or character in a position.


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

Active User


Joined: 06 Sep 2007
Posts: 112
Location: India

PostPosted: Thu Dec 06, 2007 9:56 am
Reply with quote

Hi

In the INCLUDE COND the basic syntax is (5,5,CH,EQ,C'ABDFE') i.e.
the value present in the position is given . I wanted to know if it is possible to check if the data in position 5 to 10 is numeric or character using INCLUDE COND.
Back to top
View user's profile Send private message
murmohk1

Senior Member


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

PostPosted: Thu Dec 06, 2007 9:59 am
Reply with quote

Ambili,

Look at the prev topic -

ibmmainframes.com/about521.html
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 Dec 06, 2007 9:35 pm
Reply with quote

You can use DFSORT's NUM function to determine if positions 5-10 are numeric or non-numeric:

For example, to include only records that are numeric, you can use this DFSORT statement:

Code:

   INCLUDE COND=(5,6,FS,EQ,NUM)


You can use NE,NUM to check for non-numeric.

For more information on NUM, see:

Use [URL] BBCode for External Links
Back to top
View user's profile Send private message
Ambili S

Active User


Joined: 06 Sep 2007
Posts: 112
Location: India

PostPosted: Fri Dec 07, 2007 4:15 pm
Reply with quote

Murali, Frank

Thanks for the solution .
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 Issues Converting From ZD to Signed N... DFSORT/ICETOOL 4
No new posts Store the data for fixed length COBOL Programming 1
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
Search our Forums:

Back to Top