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



Joined: 30 Oct 2006
Posts: 20

Points: 260

Post Posted: Tue Jan 29, 2019 7:04 pm Reply with quote    Back to top    

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

We are getting a string value 'NULL' in a field Col1 from a sequential file. This field needs to be mapped to a decimal field in Oracle as null value. We are using Oracle connector stage as target.

The job is not aborting when we are running this scenario. Zeroes are getting populated in the target Oracle table.

Are there any settings in the Oracle connector stage to abort the job in this case?

We do not want to use "If then else" logic to set the value to null like if Col1='NULL' then SetNull() else Col1 . We want the job to abort.

Please help us on this scenario.
UCDI



Group memberships:
Premium Members

Joined: 21 Mar 2016
Posts: 376

Points: 3877

Post Posted: Thu Jan 31, 2019 3:56 am Reply with quote    Back to top    

Feed it to a transformer.

In the transformer, have two output links. On one of the links, have a constraint send the data down if the column value is NULL. Also set the the link properties to abort after one row.
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