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.
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
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.
Joined: 10 Mar 2005 Posts: 478 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'
