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

Joined: 29 Aug 2014
Posts: 50
Location: Mumbai
Points: 532

Post Posted: Thu Jan 03, 2019 5:11 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I came across a page in IBM KC website which explains how to write data to Excel files and these are the first three steps mentioned.

1. Double-click Unstructured Data stage to open the stage properties.
2. From the Stage tab, select Excel from the Document type list.
3. From the Write mode list, select Create a file.

But, I do not see "Write" mode and also this stage don't accept input streams. Has anyone worked on this stage before to write to Excel file? Appreciate any input/help that I can get.

Group memberships:
Premium Members

Joined: 21 Mar 2016
Posts: 383

Points: 3950

Post Posted: Thu Jan 03, 2019 8:57 am Reply with quote    Back to top    

I use it all the time.
Its kinda like a dataset: if you have an input, you can't have an output, and if you have an output, you can't have an input. Its either the start or the end of a chain of work, in other words.

to use the stage you have to click to get the java or whatever it is external gui form to appear. You cannot really configure the stage in datastage as you normally would, most of the configuration is done in the pop up interface for that stage only.

ok so to walk through it a bit..
drop a dataset onto a new job canvas.
drop the unstructured data stage onto the canvas.
output from dataset to UD stage. This should work; I just did it.
double click and the ONLY 2 things that appear in the UD stage is document type (default excel) and write mode (default create a file).
the configure button is where you pick the excel settings (the pop up I mentioned).

if you cannot connect the dataset and the UD stage, your datastage setup has some sort of problem.
Rate this response:  
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