Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum 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: 141

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 Member


Joined: 29 Apr 2008
Posts: 713
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: 141

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 Add the name in the PS file and creat... dharmaraok DFSORT/ICETOOL 9 Wed Apr 01, 2020 10:43 am
No new posts Compare Two datasets and get the 1st ... ArunkumarGanesan DFSORT/ICETOOL 6 Fri Mar 27, 2020 2:00 am
No new posts DFSORT Output file order query A_programmers DFSORT/ICETOOL 1 Thu Mar 26, 2020 11:59 pm
No new posts Error Creating KSDS file, REASON CODE... sandeep prajapati JCL & VSAM 8 Tue Mar 24, 2020 12:05 pm
No new posts Outrec IFTHEN builds data in wrong po... saikarthik94 DFSORT/ICETOOL 6 Sun Mar 01, 2020 2:14 pm

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