DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
rakesh.puli



Group memberships:
Premium Members

Joined: 22 Mar 2017
Posts: 16

Points: 136

Post Posted: Wed Jan 02, 2019 10:24 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi All,

why do we use this property in sort stage "Sort as EBCDIC"? Can anyone please explain me about this property?

Thanks
Rakesh
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42930
Location: Denver, CO
Points: 221405

Post Posted: Thu Jan 03, 2019 5:35 am Reply with quote    Back to top    

Well... not sure what kind of explanation you are looking for. You would set this property to TRUE if you were processing (sorting) EBCDIC data. This so it doesn't use the ASCII collating sequence on it, since they sort differently. Found this checking online, perhaps it might help.

_________________
-craig

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
Rate this response:  
FranklinE



Group memberships:
Premium Members

Joined: 25 Nov 2008
Posts: 737
Location: Malvern, PA
Points: 6998

Post Posted: Thu Jan 03, 2019 9:01 am Reply with quote    Back to top    

It's an easy mistake to make when processing EBCDIC character set data in the DataStage ASCII character set default environment. The setting you see is how you control that.

Sorting is on the binary data which represents the characters. The main difference between the character sets are the numerals. EBCDIC "0" is xF0, ASCII is x30, etc.

_________________
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson

Using mainframe data FAQ: http://www.dsxchange.com/viewtopic.php?t=143596 Using CFF FAQ: http://www.dsxchange.com/viewtopic.php?t=157872
Rate this response:  
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42930
Location: Denver, CO
Points: 221405

Post Posted: Thu Jan 03, 2019 10:16 am Reply with quote    Back to top    

Right... had meant to come back and mention that this was all predicated on DataStage running in an ASCII environment but got ambushed. Thanks for the catch.

_________________
-craig

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
Rate this response:  
rakesh.puli



Group memberships:
Premium Members

Joined: 22 Mar 2017
Posts: 16

Points: 136

Post Posted: Thu Jan 03, 2019 8:53 pm Reply with quote    Back to top    

Hi Chulett/Franklin,

Thank you for your replies. I understand from your replies that, In datastage by default sorting is done by ASCII character set. I would like to know what is the meaning of EBCDIC Character set. what is the difference between the ASCII Character set and EBCDIC Character set? Please share me if you have any example on this?

Thanks
Rakesh
Rate this response:  
Not yet rated
rakesh.puli



Group memberships:
Premium Members

Joined: 22 Mar 2017
Posts: 16

Points: 136

Post Posted: Thu Jan 03, 2019 11:26 pm Reply with quote    Back to top    

chulett wrote:
Well... not sure what kind of explanation you are looking for. You would set this property to TRUE if you were processing (sorting) EBCDIC data. This so it doesn't use the ASCII collating sequence on it, since they sort differently. Found this checking online, perhaps it might help.

Thanks, Chulett. This thread is useful.
Rate this response:  
Not yet rated
FranklinE



Group memberships:
Premium Members

Joined: 25 Nov 2008
Posts: 737
Location: Malvern, PA
Points: 6998

Post Posted: Fri Jan 04, 2019 7:10 am Reply with quote    Back to top    

Rakesh,

Find the charts for the character sets, showing the characters and their hexadecimal values. Put EBCDIC and ASCII side by side.

I suggest finding older charts which stop at xFF or before. Extended character sets will get confusing after that.

_________________
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson

Using mainframe data FAQ: http://www.dsxchange.com/viewtopic.php?t=143596 Using CFF FAQ: http://www.dsxchange.com/viewtopic.php?t=157872
Rate this response:  
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42930
Location: Denver, CO
Points: 221405

Post Posted: Fri Jan 04, 2019 10:33 am Reply with quote    Back to top    

Sorry, didn't realize you weren't any kind of familiar with EBCDIC. Another possibly helpful URL:

https://en.wikipedia.org/wiki/EBCDIC

_________________
-craig

The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
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



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours