database - how to pass Empty string string into a xml file using Datastage? -


this xsd being used in job create xml output file fetching records tables:

<?xml version="1.0" encoding="utf-8"? <xsd:schema xmlns:xsd="http://www.w3.org/2001/xmlschema" elementformdefault="qualified" attributeformdefault="unqualified" version="1.0">     <xsd:element name="manifest">         <xsd:complextype>             <xsd:sequence>                 <xsd:element name="header">                     <xsd:complextype>                         <xsd:sequence>                             <xsd:element name="submissiondate" type="xsd:date"/>                             <xsd:element name="submissiontime" type="xsd:time"/>                             <xsd:element name="requestingapplication" type="xsd:string"/>                             <xsd:element name="contenttype" type="xsd:string"/>                         </xsd:sequence>                     </xsd:complextype>                 </xsd:element>                 <xsd:element name="documents">                     <xsd:complextype>                         <xsd:sequence>                             <xsd:element name="document" maxoccurs="unbounded">                                 <xsd:complextype>                                     <xsd:sequence>                                         <xsd:element name="searchmetadata" minoccurs="1" maxoccurs="unbounded">                                             <xsd:complextype>                                                 <xsd:sequence>                                                     <xsd:element name="attribute" maxoccurs="unbounded">                                                         <xsd:complextype>                                                             <xsd:sequence>                                                                 <xsd:element name="name" type="xsd:string"/>                                                                 <xsd:element name="value" type="xsd:string"/>                                                             </xsd:sequence>                                                         </xsd:complextype>                                                     </xsd:element>                                                 </xsd:sequence>                                             </xsd:complextype>                                         </xsd:element>                                         <xsd:element name="updatemetadata" minoccurs="1" maxoccurs="unbounded">                                             <xsd:complextype>                                                 <xsd:sequence>                                                     <xsd:element name="attribute" maxoccurs="unbounded">                                                         <xsd:complextype>                                                             <xsd:sequence>                                                                 <xsd:element name="name" type="xsd:string"/>                                                                 <xsd:element name="value" type="xsd:string"/>                                                             </xsd:sequence>                                                         </xsd:complextype>                                                     </xsd:element>                                                 </xsd:sequence>                                             </xsd:complextype>                                         </xsd:element>                                     </xsd:sequence>                                 </xsd:complextype>                             </xsd:element>                         </xsd:sequence>                     </xsd:complextype>                 </xsd:element>                 <xsd:element name="trailer">                     <xsd:complextype>                         <xsd:sequence>                             <xsd:element name="documentcount" type="xsd:int"/>                         </xsd:sequence>                     </xsd:complextype>                 </xsd:element>             </xsd:sequence>             <xsd:attribute name="batchid" type="xsd:string"/>         </xsd:complextype>     </xsd:element> </xsd:schema> 

now when not getting records table documents part in output file showing : not showing other child elements , . possible create file having documents part below:

<documents/>    <document/>       <searchmetadata/> ........ ..... .. 


Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -