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: 39139
Location: Denver, CO
Points: 199869

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

If you try and take a cat apart to see how it works, the first thing you have on your hands is a non-working cat. -- Douglas Adams
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