Checking field is Numeric

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER
ram23bal
Posts: 32
Joined: Sat May 24, 2008 3:57 pm
Skillset: COBOL
REXX
JCL
IMS DB
Referer: google

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..?

User avatar
Frank Yaeger
Global moderator
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Skillset: DFSORT, ICETOOL, ICEGENER
Referer: Search
Contact:

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:

Code: Select all

    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


  • Similar Topics
    Replies
    Views
    Last post