|
View previous topic :: View next topic
|
| Author |
Message |
anjani shanker
New User
.jpg)
Joined: 26 Jan 2007
Posts: 37
Location: USA
|
|
|
|
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 |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10874
Location: italy
|
|
|
|
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  |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| Is this a system for some Government department? Otherwise, up to 0.05 difference usually counts as a difference :-) |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
anjani shanker
New User
Joined: 26 Jan 2007
Posts: 37
Location: USA
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
mprobst
New User
.jpg)
Joined: 14 Oct 2006
Posts: 14
Location: Appleton Wi USA
|
|
|
|
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 |
|
|
robert, galambos
New User
Joined: 24 Aug 2012
Posts: 5
Location: canada
|
|
|
|
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 |
|
|
|
|
