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



Joined: 21 Aug 2017
Posts: 5

Points: 88

Post Posted: Tue May 22, 2018 3:50 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi,

I am working on CFF stage to read a mainframe file.

Until now this is what I have tried out.

Option 1 :
In a parallel job I tried to used a CFF stage to read the mainframe file and write it to sequential file.

But because of "OCCURS DEPENDING ON CLAUSE" the array is not flattening and the data is visible as junk characters.

Option 2:

In a server job I tried the CFF stage here since the array can be flattened when metadata is being loaded the required columns are there but data for columns with GROUP are showing junk.

Kindly help me out here any ideas on how to handling ODO would a be very helpful.

Please do let me know if any more information is needed.

Thanks in advance.

_________________
Rebe
FranklinE



Group memberships:
Premium Members

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

Post Posted: Tue May 22, 2018 7:37 am Reply with quote    Back to top    

I recently posted a FAQ about CFF. The link to the post is at the bottom of this post. Read about editing the copybook before loading it with the Import Wizard.

Occurs depending and groups are definitely problem areas needing attention before loading the table definition. One thing about ODO: you might not be able to resolve it, because it is essentially one large VarChar field, and you can't predict how long it will be. I've not had to deal with it in my projects, so don't hesitate to experiment and post your efforts and results.

_________________
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
rebamu
Participant



Joined: 21 Aug 2017
Posts: 5

Points: 88

Post Posted: Wed May 23, 2018 4:01 am Reply with quote    Back to top    

Thank you Frank I will try and let you know my findings.

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