I am using the Xmltocursor command to copy data from an xml file to the cursor and then create a view from the cursor like
XMLTOCURSOR(lcXML, "mycursor", 512)
REATE SQL VIEW Lvbatch as select * from mycursor.

The problem is that the XLM file has child elements within the parent element tag like

<claim>
<claim_no> xxxxx</claim_no>
-<claim_line>
<DOS>3/11/2006</DOS>
<DOE> 4/12/2006</DOE>
</claim_line>
 </claim>

Due to this the view doesnot show me the

<DOS>  and <DOE>

segments, rather append all the data of these segments under claim_line (parent segment) field. Do I have to use the Schema? If yes how to proceed for it? Or is there any other method also? Also the large field names are truncated.

Thanks
Bharat