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: 397
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 calculate the record count and based ... naveensrimf DFSORT/ICETOOL 1 Tue Jan 08, 2019 11:20 pm
No new posts Add week number to a file name or rep... tejdeep0274 JCL & VSAM 2 Thu Jan 03, 2019 6:49 am
No new posts MQ-DATA-LENGTH is ZERO on MQGET Daniel Prosser Java & MQSeries 5 Tue Dec 18, 2018 5:41 pm
No new posts Transferring file to Mainframes Shinoj Vijayakumar IBM Tools 3 Thu Dec 06, 2018 2:35 pm
No new posts Convert VBA file to FB! Vignesh Sid SYNCSORT 5 Mon Dec 03, 2018 1:27 pm

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