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



Group memberships:
Premium Members

Joined: 17 Jul 2007
Posts: 19

Points: 166

Post Posted: Thu Jun 21, 2018 3:45 pm Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Hi, we have a requirement to create a CFF files that needs to go up to the MF, and in the file there needs to be an ODO. We are able to read MF files with ODO's on the inputs but now we need to create them on the output. I had read that this is not supported in the CFF stage. Does anyone know if this can be done either thru the CFF stage or another way?

thanks
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54414
Location: Sydney, Australia
Points: 295131

Post Posted: Thu Jun 21, 2018 6:24 pm Reply with quote    Back to top    

Parallel job (as marked) or server job (as posted)?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
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: 42803
Location: Denver, CO
Points: 220637

Post Posted: Thu Jun 21, 2018 6:39 pm Reply with quote    Back to top    

Based on previous postings, let's go with Parallel. Wink

Moved to the PX forum, easy enough to move back if needed.

_________________
-craig

"I don't mind you comin' here and wastin' all my time time"
Rate this response:  
Not yet rated
Griffin07



Group memberships:
Premium Members

Joined: 17 Jul 2007
Posts: 19

Points: 166

Post Posted: Fri Jun 22, 2018 2:49 am Reply with quote    Back to top    

yes, parallel jobs
Rate this response:  
Not yet rated
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16318
Location: Germany
Points: 92566

Post Posted: Fri Jun 22, 2018 5:52 am Reply with quote    Back to top    

As you've found, writing to an occurs-depending-on using CFF isn't supported. While you could use a transform stage to "build" your variable-length Output record or perhaps use the make-vector stage, I think it might be easiest to define a fixed-occurrence OCCURS and fill the unused elements with a character value that cannot appear the file, then post-process the line (using sed or perl or awk or tr) and removing all occurrences of that character. That will effectively give you the same Thing as you would have gotten with a real occurs-depending-on.

_________________

Image
Rate this response:  
Not yet rated
Griffin07



Group memberships:
Premium Members

Joined: 17 Jul 2007
Posts: 19

Points: 166

Post Posted: Fri Jun 22, 2018 6:07 am Reply with quote    Back to top    

Hi ArndW, the sed/pearl option sounds promising, we would need to run it on the file after it comes out of the CFF stage and has been converted to EBCDIC?
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