I just wrote an application which creates XML file from the table. All you
hava to do is to to give the table name and it will generate the XML. My
Question, i just wanted to know, whether the XML generated is correct. If
there is any mistake, please do bear with me and any corrections and help is
welcome.
For your reference, i am attaching a generated XML file:
<?XML version = "1.0" ?>
<!DOCTYPE DOCUMENT [
<!ELEMENT DOCUMENT (ACTION)*>
<!ELEMENT ACTION(ACTION_ID,ACTION_DESCR,ACTIVESW,USER_ID,TIME_STAMP)>
<!ELEMENT ACTION_ID (#PCDATA)>
<!ELEMENT ACTION_DESCR (#PCDATA)>
<!ELEMENT ACTIVESW (#PCDATA)>
<!ELEMENT USER_ID (#PCDATA)>
<!ELEMENT TIME_STAMP (#PCDATA)>
]>
<DOCUMENT>
<ACTION>
<ACTION_ID>A</ACTION_ID>
<ACTION_DESCR>Activate</ACTION_DESCR>
<ACTIVESW>A</ACTIVESW>
<USER_ID>PASSTEST</USER_ID>
<TIME_STAMP>1998-02-23 09:44:00.000</TIME_STAMP>
</ACTION>
<ACTION>
<ACTION_ID>E</ACTION_ID>
<ACTION_DESCR>Re-Evaluate</ACTION_DESCR>
<ACTIVESW>A</ACTIVESW>
<USER_ID>PASSTEST</USER_ID>
<TIME_STAMP>1998-02-23 09:44:00.000</TIME_STAMP>
</ACTION>
<ACTION>
<ACTION_ID>F</ACTION_ID>
<ACTION_DESCR>ReFund</ACTION_DESCR>
<ACTIVESW>A</ACTIVESW>
<USER_ID>PASSTEST</USER_ID>
<TIME_STAMP>1998-02-23 09:44:00.000</TIME_STAMP>
</ACTION>
<ACTION>
<ACTION_ID>G</ACTION_ID>
<ACTION_DESCR>Migration</ACTION_DESCR>
<ACTIVESW>A</ACTIVESW>
<USER_ID>PASSTEST</USER_ID>
<TIME_STAMP>1998-02-23 09:44:00.000</TIME_STAMP>
</ACTION>
<ACTION>
<ACTION_ID>I</ACTION_ID>
<ACTION_DESCR>Increase</ACTION_DESCR>
<ACTIVESW>A</ACTIVESW>
<USER_ID>PASSTEST</USER_ID>
<TIME_STAMP>1998-02-23 09:44:00.000</TIME_STAMP>
</ACTION>
<ACTION>
<ACTION_ID>R</ACTION_ID>
<ACTION_DESCR>Renew</ACTION_DESCR>
<ACTIVESW>A</ACTIVESW>
<USER_ID>PASSTEST</USER_ID>
<TIME_STAMP>1998-02-23 09:44:00.000</TIME_STAMP>
</ACTION>
</DOCUMENT>
Thanks & Bye ,
Vaiyapuri Subramanian ,
( O ) 800 / 933 - 7642 x 3278 .
( R ) 336 / 759 - 0777 x 614 .