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



Group memberships:
Premium Members

Joined: 17 Dec 2007
Posts: 7
Location: Boston, MA
Points: 55

Post Posted: Sun Feb 03, 2008 7:50 am Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Windows
I tried both Sequencial and Complex Flat File stage to transform EBCDIC file into ASCII file. It works well for transforming char. But it will always get import error when transforming packed decimal.

For example, the packed decimal 27 0f in the EBCDIC file is supposed to be transformed into decimal 270 in ASCII. But I got the log below:

Field "col1" has import error and no default value; data: { ' 0f }, at offset: 0

Is there something wrong when importing the file? ( ' is the ASCII character for 27). I have already set the character set to EBCDIC.
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 38847
Location: Denver, CO
Points: 198341

Post Posted: Sun Feb 03, 2008 8:10 am Reply with quote    Back to top    

Packed is packed and is neither ASCII nor EBCDIC. So while you do indeed need to convert character data as you've noted, packed fields need no such thing, and any 'conversion' will destroy them. You s ...

_________________
-craig

"Do unto those downstream as you would have those upstream do unto you."
Rate this response:  
Not yet rated
Aruna Gutti



Group memberships:
Premium Members

Joined: 21 Sep 2007
Posts: 145
Location: Boston
Points: 989

Post Posted: Thu Feb 07, 2008 11:47 am Reply with quote    Back to top    

What is the Data Style or Data Format specification for your input file ? Where is your input file coming from ?

Usually this is how I define my CFF input source from Mainframe.

Character set : EBCDIC

Data Style / Data format ( depending on DataStage version : Binary

Regards,

Aruna.
Rate this response:  
Not yet rated
bcarlson



Group memberships:
Premium Members

Joined: 01 Oct 2004
Posts: 772
Location: Minnesota
Points: 7799

Post Posted: Thu Feb 07, 2008 4:04 pm Reply with quote    Back to top    

There have been other postings about converting EBCDIC to ASCII, and how to deal with numeric data.

Here are a couple of topics to look at:

How to convert the signed decimal

Mainframe MVS File to SF/CFF stage. Values Incorrect

Hope this helps.

Brad.
Rate this response:  
Not yet rated
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