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>