MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Jcl to Convert Null to Space

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL)
View previous topic :: View next topic  
Author Message
arvibala
Beginner


Joined: 12 Feb 2008
Posts: 142
Topics: 67

PostPosted: Mon Jul 20, 2009 8:11 pm    Post subject: Jcl to Convert Null to Space Reply with quote

Hi all,

I have a flat file (FB 200) created from database extract. The file has embeded Null values (x'00'). This is causing problem. Can we have a simple JCL that converts all Null (x'00') into space (x'40')?

Thanks
_________________
Arvind
"You can make a difference with your smile. Have that with you always"
Back to top
View user's profile Send private message Yahoo Messenger  
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose

PostPosted: Mon Jul 20, 2009 8:24 pm    Post subject: Reply with quote

arvibala,

Please search before posting. Check this link

http://mvsforums.com/helpboards/viewtopic.php?p=1475#1475
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website  
arvibala
Beginner


Joined: 12 Feb 2008
Posts: 142
Topics: 67

PostPosted: Mon Jul 20, 2009 9:33 pm    Post subject: Reply with quote

Thanks Kolusu,

I did search using NULL, didnot find any and thats the reason posted. Thanks again
_________________
Arvind
"You can make a difference with your smile. Have that with you always"
Back to top
View user's profile Send private message Yahoo Messenger  
dbzTHEdinosauer
Supermod


Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany

PostPosted: Tue Jul 21, 2009 1:17 am    Post subject: Reply with quote

that's because NULL is not the correct word to use: low-values or binary zeroes is the term you are looking for.
_________________
Dick Brenholtz
American living in Varel, Germany
Back to top
View user's profile Send private message  
arvibala
Beginner


Joined: 12 Feb 2008
Posts: 142
Topics: 67

PostPosted: Tue Jul 21, 2009 8:30 am    Post subject: Reply with quote

Thanks All for the Help. I have to use the search effectively.

I have few concerns. This is an IDMS database extract. In what cases these low values or binary zeros appear? If they do any correction in Online region, can these happen?

And If a particular field is a numeric field and it has a Low value, I cant blindly convert that to Space using above code .. correct? To be efficient, I had to write a COBOL / EZT code.

Pls suggest if there is any alternative in JCL?
_________________
Arvind
"You can make a difference with your smile. Have that with you always"
Back to top
View user's profile Send private message Yahoo Messenger  
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose

PostPosted: Tue Jul 21, 2009 11:26 am    Post subject: Reply with quote

arvibala wrote:
And If a particular field is a numeric field and it has a Low value, I cant blindly convert that to Space using above code .. correct? To be efficient, I had to write a COBOL / EZT code.


arvibala,

I have no clue as to how binary zeros would appear in IDMS but you need to real careful replacing the binary zeros with spaces as you may mess up packed or binary fields that have hex zeros in the first couple of bytes.

Quote:
Pls suggest if there is any alternative in JCL?


The above suggested solutions are indeed very efficient solutions. You can limit your replacement of low values to spaces only for character data.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website  
arvibala
Beginner


Joined: 12 Feb 2008
Posts: 142
Topics: 67

PostPosted: Wed Jul 22, 2009 7:23 am    Post subject: Reply with quote

Thanks Kolusu.

With these tips, I will make an efficient code.
_________________
Arvind
"You can make a difference with your smile. Have that with you always"
Back to top
View user's profile Send private message Yahoo Messenger  
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Job Control Language(JCL) All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group