Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Tolerance in File Aid

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

New User


Joined: 26 Jan 2007
Posts: 37
Location: USA

PostPosted: Fri Jul 13, 2012 7:40 pm    Post subject: Tolerance in File Aid
Reply with quote

Hi,

I am trying to compare 2 files having char and fixed decimal fields. They have amount differences. I know there is a functionality of mentioning tolerance value in FILE AID as I don’t want differences of up to 5 cents to be displayed. Can you help me? I need to know what are the specifications for tolerance value and how it is mentioned? Any help is appreciated!


Code:
[code][code]File-AID ----------- Compare - Formatted Criteria -----------------------
C _Œ_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹ Tolerance Value Specification _¹
  _4                                             INVALID TOLERANCE VALUE _4
O _4  Command ===> 0.05                              (End, Cancel, Help) _4
  _4                                                                     _4
  _4  OLD field name: SUPP_TP                        Format: PS  7  2    _4
  _4  NEW field name: SUPP_TP                        Format: PS  7  2    _4
  _4                                                                     _4
  _4  F1=TOP       F2=RES       F3=END       F4=RETURN    F5=RFIND       _4
  _4  F6=RCHANGE   F7=UP        F8=DOWN      F9=SWAP     F10=LEFT        _4
  _‹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_¹_
  _    SUPP_ADJ_IND                      C      1 COMPARISON FIELD       
  _    ANTY_AIPP_TP                      PS  7  2 COMPARISON FIELD       
  _    ANTY_AIPP_EXTD_TP                 PS  7  2 COMPARISON FIELD       
  T    SUPP_TP                           PS  7  2 COMPARISON FIELD       
  _    SUPP_EXTD_TP                      PS  7  2 COMPARISON F[/code]IELD  [/code]     
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Fri Jul 13, 2012 7:45 pm    Post subject: Reply to: Tolerance in File Aid
Reply with quote

googling for fileaid comparison tolerance returned 14000 hits, the first few of which contain the solution/hints to Your question.

no reason that You should not have found out by Yourself icon_evil.gif
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7225

PostPosted: Fri Jul 13, 2012 8:19 pm    Post subject: Reply to: Tolerance in File Aid
Reply with quote

Is this a system for some Government department? Otherwise, up to 0.05 difference usually counts as a difference :-)
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jul 13, 2012 8:35 pm    Post subject:
Reply with quote

Hi Bill,

Something like this came up a while back and i learned a (for me) new term . . .

At issue was a difference of about $5 million (out of a total of about $4 billion). Someone who was more than a little lazy (and somewhat incompetent) said this was OK as it was "Materially Correct".

I 'splained that nothing like this was going out with my name attached to it. Fortunately this came up on a Thursday and a long weekend of digging identified the problem - different "rules" for different code. . .
Back to top
View user's profile Send private message
anjani shanker

New User


Joined: 26 Jan 2007
Posts: 37
Location: USA

PostPosted: Fri Jul 13, 2012 8:44 pm    Post subject:
Reply with quote

Hey! I have already googled it but no good answer. It seems there was one document built long back having some Mainframe tips and same thing has been published on multiple websites.

Cents don't matter here. It could be anything, what I need to know is how to mention it. I am still looking for a solution to my question!!

thanks for any help!
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7225

PostPosted: Fri Jul 13, 2012 9:04 pm    Post subject: Reply to: Tolerance in File Aid
Reply with quote

anjani shanker,

If the cents are so unimportant, I volunteer to take them all off your ha

What was wrong with the answer you ot from googling?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Jul 14, 2012 12:00 am    Post subject:
Reply with quote

Hello,

If you can find what you want neither in the manuals nor on the web, suggest you open an issue with File-Aid Support.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Jul 14, 2012 12:20 am    Post subject:
Reply with quote

Hello,

Quote:
Hey! I have already googled it but no good answer.
You need to practice how to search . . .

The following is from the first link returned using fileaid comparison tolerance as the search value. . .

Quote:
My requirement is to compare 2 files of which for one certain field I can have + or - 1 value which should
be acceptable while comparing.
Thru FILE-AID COMPARE (OPTION 10), one can set percentage amount for numeric
fields that determines "close enough" matches. When the "Formatted Criteria" table
appears after the 2 files are specified, use the "T" line command. This brings up a

"Tolerance Value/Percentage Specification" panel where you can set a plus or minus
value for a numeric field.


Is this not similar to what you want. . .
Back to top
View user's profile Send private message
mprobst

New User


Joined: 14 Oct 2006
Posts: 14
Location: Appleton Wi USA

PostPosted: Mon Jul 23, 2012 9:27 pm    Post subject: Reply to: Tolerance in File Aid
Reply with quote

Here is the description of how to enter tolerance on the Fileaid panel
Code:
-------------- Tolerance Value/Percentage Specification --------------

  Command ===>                                   (End, Cancel, Help)

  OLD field name: YE-DIS-ID                      Format: Z   1
  NEW field name: YE-DIS-ID                      Format: Z   1

  Specify tolerance value/percentage ===>

  To set one tolerance (plus or minus),
  1) Preceed tolerance with a "+" to only allow the plus variance, or
  2) Preceed tolerance with a "-" to only allow the minus variance.

  To set both plus and minus tolerance to the same value/percentage,
  omit the "+" and "-".
Back to top
View user's profile Send private message
robert, galambos

New User


Joined: 24 Aug 2012
Posts: 5
Location: canada

PostPosted: Mon Aug 27, 2012 1:44 am    Post subject:
Reply with quote

tolerances are only in the compare function.

they can be minus, plus or both

they can be number, or a percentage

robert

compuware
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 PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us