View previous topic :: View next topic
|
Author |
Message |
Abhishek_kumar_81
New User
Joined: 03 Jun 2005 Posts: 4
|
|
|
|
For VSAM files, for alphanumeric fields, I am using default values which is Low values. For the same field in DB2, I am using default values which are spaces. My program is not manipulating these variables at all. So they are having their default values.Now if I am comparing these two fields, I am getting mismatch which actually should not be a mismatch. Can somebody please help me to solve this problem such that while comparing it should not give me any mismatch for these default values. |
|
Back to top |
|
|
priya
Moderator
Joined: 24 Jul 2003 Posts: 568 Location: Bangalore
|
|
|
|
Low-Values and Spaces are not same. |
|
Back to top |
|
|
mdtendulkar
Active User
Joined: 29 Jul 2003 Posts: 237 Location: USA
|
|
|
|
Abhishek_kumar_81,
As stated by Priya, Low values and Spaces are not same, you can try implementing this solution
Code: |
If VSAM File field = Low Values AND
DB2 field = SPACES
set SAME-Field to TRUE
Else
IF VSAM File Field = DB2 Field
Set SAME-Field to TRUE
Else
Set Not-SAME-Field to TRUE
end if
end if |
Hope this helps
Regards
Mayuresh |
|
Back to top |
|
|
Abhishek_kumar_81
New User
Joined: 03 Jun 2005 Posts: 4
|
|
|
|
What if I have thousand of fields like this in my VSAM files and DB2 tables?? The solution given by you will be very cumbersome and will hard to maintain. |
|
Back to top |
|
|
MGIndaco
Active User
Joined: 10 Mar 2005 Posts: 432 Location: Milan, Italy
|
|
|
|
Update your fields in DB2 or in VSAM and in one of this change its default.
If you cannot you must write some line of source...
Difference between low value and space is easy.
low value in hex is '00'
space in hex is '40' |
|
Back to top |
|
|
|