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
 

 

Low values in VSAM and Spaces in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Abhishek_kumar_81

New User


Joined: 03 Jun 2005
Posts: 4

PostPosted: Fri Jun 03, 2005 5:33 pm    Post subject: Low values in VSAM and Spaces in DB2
Reply with quote

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
View user's profile Send private message

priya

Moderator


Joined: 24 Jul 2003
Posts: 568
Location: Bangalore

PostPosted: Sun Jun 05, 2005 12:45 am    Post subject:
Reply with quote

Low-Values and Spaces are not same.
Back to top
View user's profile Send private message
mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Sun Jun 05, 2005 2:07 am    Post subject:
Reply with quote

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
View user's profile Send private message
Abhishek_kumar_81

New User


Joined: 03 Jun 2005
Posts: 4

PostPosted: Fri Jun 10, 2005 7:02 pm    Post subject: Re: Low values in VSAM and Spaces in DB2
Reply with quote

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
View user's profile Send private message
MGIndaco

Active User


Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy

PostPosted: Fri Jun 10, 2005 8:14 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts BI,TO=ZD Changing Values Tyler Dunbar DFSORT/ICETOOL 4 Tue Jul 25, 2017 12:12 am
No new posts Sorting of hex values Saurabh_mi DFSORT/ICETOOL 11 Thu May 25, 2017 3:49 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am
No new posts Compare two files and subtract values ameetmund DFSORT/ICETOOL 7 Fri Mar 31, 2017 3:35 pm


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