[
Lists Home |
Date Index |
Thread Index
]
Hi,
I would like to get your urgent help on use of XML,XSLT and XSD
Scenario
In my case I have XML file that you can find in attachment. It have information (ColumnName+Data) related to DML operation that we have performed on a table.
I would like to rewrite the XML only having data instead of Schema information like table name, ColumnName etc. I have required to define schema information
anywhere else using xsd or xsl.
If I write schema information in a XSD then is it require to give the column Name and Table Name in XML also?
Is it not required to write it again in XML file then How to Map the XSD in XML ?
Is XSL is useful here?
Is XML , XSD and XSL all are required to use it. If require what is the role of each.
Is XSL is used to map the XSD file with XML ?
I hope that u will understand my scenario and help me to solve the problem.
Waiting for your prompt reply.
Regards,
Sube Singh
<?xml version="1.0" encoding="ISO-8859-1"?><root><tableName>DBO.STUDENT<operation>D<primary><pk name="rollNo"><![CDATA[1]]></pk>
</primary></operation>
<operation>U<row><col name="c1"><![CDATA[1]]></col>
<col name="c2"><![CDATA[Two]]></col>
<col name="c3"><![CDATA[NULL]]></col>
<col name="c4"><![CDATA[NULL]]></col>
</row><ChangedCol><changesCol name="rollNo"><![CDATA[1]]></changesCol></ChangedCol><primary><pk name="rollNo"><![CDATA[2]]></pk>
</primary></operation>
<operation>U<row><col name="c1"><![CDATA[0]]></col>
<col name="c2"><![CDATA[Three]]></col>
<col name="c3"><![CDATA[NULL]]></col>
<col name="c4"><![CDATA[NULL]]></col>
</row><ChangedCol><changesCol name="rollNo"><![CDATA[0]]></changesCol></ChangedCol><primary><pk name="rollNo"><![CDATA[3]]></pk>
</primary></operation>
<operation>U<row><col name="c1"><![CDATA[3]]></col>
<col name="c2"><![CDATA[Four]]></col>
<col name="c3"><![CDATA[NULL]]></col>
<col name="c4"><![CDATA[NULL]]></col>
</row><ChangedCol><changesCol name="rollNo"><![CDATA[3]]></changesCol></ChangedCol><primary><pk name="rollNo"><![CDATA[4]]></pk>
</primary></operation>
<operation>I<row><col name="c1">4</col>
<col name="c2"><![CDATA[FourAgain]]></col>
<col name="c3">NULL</col>
<col name="c4">NULL</col>
</row><primary><pk name="rollNo"><![CDATA[4]]></pk>
</primary></operation>
<operation>I<row><col name="c1">2</col>
<col name="c2"><![CDATA[ TwoAgain ]]></col>
<col name="c3">NULL</col>
<col name="c4">NULL</col>
</row><primary><pk name="rollNo"><![CDATA[2]]></pk>
</primary></operation>
</tableName>
</root>
| 