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



Joined: 08 Jan 2008
Posts: 40

Points: 360

Post Posted: Wed May 16, 2018 1:04 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I have a Job that reads XML messages from MQ Connector. All potential fields/columns are mapped to a target table. However, some elements (most) are nullable and sometimes do NOT appear in the XML (tns header and element text() is missing)...

In this case, Datastage would show a warning:
" [columnname]... in input data set 0 not present in design time information. Extended field properties for this field will not be available."

Is there a way to avoid/resolve this warning?

The field is set as NULLABLE in the XMLInput stage and throughout the transformer to target table.
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3751

Points: 30025

Post Posted: Wed May 16, 2018 1:18 pm Reply with quote    Back to top    

It's not clear to me when it exactly is happening. The xmlInput Stage normally does not care if an element or attribute doesn't appear in the incoming document. It simply returns nulls, or in the c ...

_________________
Ernie Ostic

blogit!
Open IGC is Here!
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