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 how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts Overlaying one set of charater values... Kevin Lindsley SYNCSORT 7 Sat Nov 05, 2016 3:21 am


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