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
Post a Comment