DSXchange

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

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

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.

Are you talking about value file related to paramter set ?

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

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.

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

... tom

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

You can also have conditional logic based on that.

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

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