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
 
File Aid tool to compare numeric data

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
balaji81_k

Active User


Joined: 29 Jun 2005
Posts: 118

PostPosted: Tue Sep 26, 2017 3:35 am    Post subject: File Aid tool to compare numeric data
Reply with quote

Hi Team,

I have used FILE-AID Step in Batch JCL to compare Date and hour .
Hour is in Numeric data (pic 9(02)). Problem is Numeric condition fails and it is not even working on .

I referred manual it says for numeric data compare it needs to use
N'02' like.


Code:

COPY IF=(1,EQ,C'2017-09-21'),
      AND=(11,GE,N'02')


And condtion is not even have control . Please advise me what i am missing here .
Back to top
View user's profile Send private message

sergeyken

Active User


Joined: 29 Apr 2008
Posts: 189
Location: Maryland

PostPosted: Tue Sep 26, 2017 11:16 pm    Post subject:
Reply with quote

The manual "File-AID/MVS Batch Reference Release 17.02" doesn't define any constant data type as N'...'
Back to top
View user's profile Send private message
balaji81_k

Active User


Joined: 29 Jun 2005
Posts: 118

PostPosted: Sat Sep 30, 2017 1:45 am    Post subject:
Reply with quote

Hi Sergeyken,

Sorry for the delayed response. My bad i misunderstood the manual .
Any numeric data can be compared with BATCH JCL using FILE-AID provided they have specify the complete length or starting position of number actually needs to check . This will applicable only for variables declared as numeric PIC 9(n) . In my case i need to use simply



Code:

COPY IF(1,EQ,C'2017-09-29',
           11,GE,C'02')


Using "C" we can compare numeric data and specify full length if required or use the position exactly .
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 -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts Garbage on output file Hervey Martinez SYNCSORT 4 Wed Sep 27, 2017 12:50 am

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