Checking field is Numeric



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Checking field is Numeric

Postby ram23bal » Tue Oct 07, 2008 1:09 pm

Hi all

I have requirement where Iam geting Inrec file using JCL.
I want to check whether a particular fields is numeric or alphanumeric.
Say for example field in location 1-10, whether this is numeric or alphanumeric.
Is there any Numeric check in JCLs..?
ram23bal
 
Posts: 32
Joined: Sat May 24, 2008 3:57 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Checking field is Numeric

Postby Frank Yaeger » Tue Oct 07, 2008 8:35 pm

You can use DFSORT's NUM function to check for numerics or non-numerics.

For more information, see:

http://publibz.boulder.ibm.com/cgi-bin/ ... 0615173822

For example:

    OPTION COPY
    INREC IFTHEN=(WHEN=(1,10,FS,EQ,NUM),BUILD=(...)),
          IFTHEN=(WHEN=(1,10,FS,NE,NUM),BUILD=(...))     


If you want more specific help, you need to describe what you want to do in more detail.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post