IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

File Aid tool to compare numeric data


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
balaji81_k

Active User


Joined: 29 Jun 2005
Posts: 155

PostPosted: Tue Sep 26, 2017 3:35 am
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

Senior Member


Joined: 29 Apr 2008
Posts: 2010
Location: USA

PostPosted: Tue Sep 26, 2017 11:16 pm
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: 155

PostPosted: Sat Sep 30, 2017 1:45 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top