Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Find 5 continuous numeric data in a record

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Shrinika Rajendran

New User


Joined: 06 Jun 2013
Posts: 25
Location: India

PostPosted: Tue Dec 09, 2014 12:48 pm    Post subject: Find 5 continuous numeric data in a record
Reply with quote

Hi all,
I need to find records that have 5 numbers continuously. It is fine to find if the data is numeric in a particular position.

But, is it possible to somehow mention the number of numeric positions we are looking for in a record?

Thanks in advance
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8619
Location: Back in jolly old England

PostPosted: Tue Dec 09, 2014 2:49 pm    Post subject:
Reply with quote

I suggest that you take a step back and consider thinking about how best to ask your question.

So far it's about as clear as mud, so you probably will not get any help at all.

Think about how you would like someone else to explain their problem to you
Back to top
View user's profile Send private message
Shrinika Rajendran

New User


Joined: 06 Jun 2013
Posts: 25
Location: India

PostPosted: Tue Dec 09, 2014 3:38 pm    Post subject:
Reply with quote

I want to do numeric check on the fields. But not just at a particular position. But scan thru a particular length of record and find out if that record has five number continuously anywhere in that length.

Code:
----+----1----+----2
********************
121 MINT STREET
COL SD 4436 NATL HWY   
TAKE 18428 TULIP   


Here, I would want to check thru positions 1-20. The third record has 5 numbers. I want only this record.

Please let me know if you need any more details.

Thanks
Back to top
View user's profile Send private message
boyti ko

New User


Joined: 03 Nov 2014
Posts: 78
Location: Malaysia

PostPosted: Tue Dec 09, 2014 4:57 pm    Post subject:
Reply with quote

in command line, you can use
FIND P'#####'
and you will find that number
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10374
Location: italy

PostPosted: Tue Dec 09, 2014 5:02 pm    Post subject: Reply to: Find 5 continuous numeric data in a record
Reply with quote

the TS wanted a jcl solution ( probably a <sort> solution )
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1072
Location: Oostende, Belgium

PostPosted: Tue Dec 09, 2014 5:02 pm    Post subject:
Reply with quote

Unless this is some (censored) homework request, what is the use of doing this?????
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10374
Location: italy

PostPosted: Tue Dec 09, 2014 5:12 pm    Post subject: Reply to: Find 5 continuous numeric data in a record
Reply with quote

Robert,

what a silly question icon_wink.gif

You should already know that the reply would be ...

that' s the requirement


icon_biggrin.gif
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Tue Dec 09, 2014 7:06 pm    Post subject: Reply to: Find 5 continuous numeric data in a record
Reply with quote

Shrinika Rajendran,

Can you show an example of what you want to do? I it still unclear.

For instance, we have no idea if you are looking for a particular five-digit number(s) or any old five-digit (or more) number will do.
Back to top
View user's profile Send private message
steve-myers

Active Member


Joined: 30 Nov 2013
Posts: 587
Location: The Universe

PostPosted: Tue Dec 09, 2014 9:53 pm    Post subject:
Reply with quote

In the US, it would be to find records containing a postal code, though there will be a lot of false hits, especially in large cities like New York.
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 query to fetch record which has only ... maxsubrat DB2 12 Mon Dec 11, 2017 5:03 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts Fetching data from JHS as per the cur... arunsoods All Other Mainframe Topics 4 Wed Nov 22, 2017 1:54 pm
No new posts Extract Record using range of Data scorp_rahul23 DFSORT/ICETOOL 3 Wed Nov 15, 2017 11:54 pm
No new posts Squeeze record left so that zeroes ar... Vignesh Sid SYNCSORT 5 Fri Nov 10, 2017 1:40 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us