XML Warnings

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dstager
Participant
Posts: 47
Joined: Tue Jan 08, 2008 8:43 am

XML Warnings

Post by dstager »

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 Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

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 case of the "repetition element", controls whether you retrieve the node or not.

Please provide more details, a comparison sample snippet of your xml document with and without the element in question, etc. ...whatever details you can.

Thanks.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Post Reply