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: 137

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: 447
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: 137

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 Mainframe to linux file count mismatch shreya19 All Other Mainframe Topics 4 Thu Jun 13, 2019 9:49 pm
No new posts Regarding mroe data to be processed i... vinu78 DB2 1 Mon May 27, 2019 7:31 pm
No new posts Copy physical Tape files to a Mainfra... Dadi Krishna Teja JCL & VSAM 11 Thu May 16, 2019 10:25 pm
No new posts masking data with HPU jzhardy DB2 0 Tue May 14, 2019 2:43 pm
No new posts How to browse RECFM=VBS DSORG=PSE seq... Alan Playford JCL & VSAM 7 Fri May 10, 2019 2:59 pm

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