Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Extend the decimal values in DIVISION Balaryan DFSORT/ICETOOL 3 Thu Oct 05, 2017 4:05 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts Working with hex values in Filemanage... Emile Straker IBM Tools 0 Tue Sep 12, 2017 1:42 am
No new posts DB2 NULL Values display V S Amarendra Reddy DB2 3 Thu Sep 07, 2017 6:59 pm
No new posts Moving values to a variable of copybo... Vignesh Sid COBOL Programming 6 Wed Sep 06, 2017 1:04 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us