Using DataStage Job to Generate Value Files

tomengers · Post by **tomengers** » Fri May 07, 2010 2:21 am

Hi Folks ...

Before I spend a ton of design time, can anyone tell me whether it is possible to use a DataStage job to generate the contents of a Value File?

I need to email the appropriate user based on the specific (Customer, Invoice, Product, etc.) error found in an earlier DataStage process.

Thanks for your input.

... tom

srinivas.g · Post by **srinivas.g** » Fri May 07, 2010 2:34 am

it is possible. use notificaton activity stage .......

ray.wurlod · Post by **ray.wurlod** » Fri May 07, 2010 2:53 am

Please be more specific about what you mean by a Value File. It's not a term that I understand a single meaning for. In what way do you intend to "generate"? And what has to be generated?

The email part is easy now that the Notification Activity supports attachments.

nagarjuna · Post by **nagarjuna** » Fri May 07, 2010 1:14 pm

Are you talking about value file related to paramter set ?

tomengers · Post by **tomengers** » Mon May 10, 2010 12:54 am

Sorry ... I was misusing the term Value Set. What I need to do is pass a value from a DataStage shared container to a Sequence.

The DataStage container is a validator - I want to pass a result to a sequence so that the correct email address may be used.

... again thanks.

... tom

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon May 10, 2010 2:39 am

You can write the records into separate bad files and send each to appropriate team. Thus a team will receive a blank file if there is no record for them to look into.

tomengers · Post by **tomengers** » Mon May 10, 2010 5:43 am

Sainath ... thanks for the response. Can I interrogate the contents of these "bad files" from within the Sequence?

... tom

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon May 10, 2010 6:19 am

Yes. You can call the OS commands to check the file properties and its contents.

You can also have conditional logic based on that.

tomengers · Post by **tomengers** » Tue May 11, 2010 12:42 am

Sainath ...

You say I can write the records into separate bad files and send each to appropriate team.

I don't understand 'bad' file ... how does the sequence access this 'bad' file?

... tom

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue May 11, 2010 2:31 am

The bad file - in this case - will be your validation results from your shared container.