Hi,
I want to display all null value fields in XML. So what I did is, I modified my .xsd file and updated all fields with nillable="true" option. And my job design is like this,
External Source Stage->XML Stage
In XML Stage, I took Parsing Step and Composing Step. In both Steps, I updated the "document root" with the modified .xsd file. But still i am not able to see my null fields in output XML. Where do you think i am going wrong?
nillable="true" not working in XML
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 50
- Joined: Fri Aug 29, 2014 1:32 pm
- Location: Mumbai
-
- Participant
- Posts: 50
- Joined: Fri Aug 29, 2014 1:32 pm
- Location: Mumbai
Please be more explicit about what you are looking for. Usually with external source we are reading xml......and if that is what you are doing, exactly what do you want to see on your resulting relational columns.....
External source and composing is a bit odd.....please describe in detail.
Thanks.
Ernie
External source and composing is a bit odd.....please describe in detail.
Thanks.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 50
- Joined: Fri Aug 29, 2014 1:32 pm
- Location: Mumbai
Sorry...not explicit enough. You say you are "reading" xml, and then later you mention "target XML".
Are you reading xml and writing to a sequential file or database?
Are you reading data from "somewhere" and then writing it into xml?
Are you trying to read xml and write xml in the same Stage?
All are do-able, but each has their complexities and requires more detail for understanding. ...and if you are just getting into xml, do only ONE of these --- don't try to combine the functions (read xml and write it at a single stage) until you fully have the independent functions working and doing what you expect them to.
...and what do you mean by "in the xml file all NULL columns are hidden" ? There is no such setting for "hiding" them. They are either "there", or they are "not there"...and if they are "there", they can be blank or empty, or they might have the "true" attribute setting for nullability.
Sorry --- we want to help, but we need a LOT more detail....especially necessary on the subject of nulls.
Ernie
Are you reading xml and writing to a sequential file or database?
Are you reading data from "somewhere" and then writing it into xml?
Are you trying to read xml and write xml in the same Stage?
All are do-able, but each has their complexities and requires more detail for understanding. ...and if you are just getting into xml, do only ONE of these --- don't try to combine the functions (read xml and write it at a single stage) until you fully have the independent functions working and doing what you expect them to.
...and what do you mean by "in the xml file all NULL columns are hidden" ? There is no such setting for "hiding" them. They are either "there", or they are "not there"...and if they are "there", they can be blank or empty, or they might have the "true" attribute setting for nullability.
Sorry --- we want to help, but we need a LOT more detail....especially necessary on the subject of nulls.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 50
- Joined: Fri Aug 29, 2014 1:32 pm
- Location: Mumbai