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



Joined: 14 Dec 2015
Posts: 56
Location: Arizona
Points: 460

Post Posted: Wed Apr 11, 2018 7:40 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: CFF File reading Cobol file
I am trying to read a COBOL file, But i am experiencing '{','}' signs in the data. My options are EBCDIC and Binary. But still seeing these values when i am trying to view the data in output tab.

I looked at many post here on DSXCHANGE, but i could'nt figure out the exact answer, Appreciate if someone can help in this.

_________________
anudpETL
FranklinE



Group memberships:
Premium Members

Joined: 25 Nov 2008
Posts: 679
Location: Malvern, PA
Points: 6425

Post Posted: Wed Apr 11, 2018 9:20 am Reply with quote    Back to top    

Many issues you'll face with Cobol data is covered in the FAQ linked at the bottom of my post.

I believe you are looking at a signed numeric field. The data is alphanumeric, but the digit with the "odd" character has been changed to contain the sign.

"0" = xF0 and in many numeric formats the half-byte value xF means unsigned.
explicit "+0" = xC0 or "{"
explicit "-0" = xD0 or "}"

The pattern repeats for digit characters 1-9. Have an EBCDIC character set chart handy.

In the table definition, the column derived from PIC S9(#) should be listed in CFF as DISPLAY NUMERIC, and have the signed attribute.

_________________
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:  
Not yet rated
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42576
Location: Denver, CO
Points: 219102

Post Posted: Wed Apr 11, 2018 9:26 am Reply with quote    Back to top    

First off, see if anything helps in the awesome FAQ that Franklin Evans put together on this subject... or at least what I assume is the same subject. Verify for us what stage you are using to read the COBOL file - the Complex Flat File stage? It also seems like posting some of your sample data would help as well and/or the CFD.

... and he sneaks in here behind me while I'm typing. Le sigh. Not going to waste all this digital ink so...

_________________
-craig

I know I don't say this enough, but I like when you talk to me. It's much better than when nobody talks to me. Or when people that I don't like will not stop talking to me.
Rate this response:  
Not yet rated
FranklinE



Group memberships:
Premium Members

Joined: 25 Nov 2008
Posts: 679
Location: Malvern, PA
Points: 6425

Post Posted: Wed Apr 11, 2018 9:30 am Reply with quote    Back to top    

Craig, the server is not happy. My post took a couple of minutes to be saved and displayed. Indeed, I expect this post to be visible sometime in the year 2022. Laughing

_________________
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:  
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