> If my XML comes out like this, how do I create the XSD to match?

<clients clientno="234-76-1044 " lname="Crandall" fname="Elizabeth">
  <objectiv objno="ABC-12" title="ABCs" />
  <objectiv objno="BEH-01" title="Decrease Tantrums" />
  <servobj objno="S-06" title="Shopping for room decorations" />
  <servobj objno="B-01  " title="Past Behavior Plans and Results" />
</clients>

Thanks in advance
Randy Hersom

>

Hi Randy!

We're using XMLTOCURSOR with 8192 to move our xml data without using a schema. Could you do something like this for your situation...

CREATE CURSOR crsResults (clientno c(11),lname c(30),obj_objno c(50), serv_objno c(50))
XMLTOCURSOR(xmlname, "crsResults", 8192)

Then just convert this back to an xml with an xsd via CURSORTOXML()

Might not be what you're looking for but just a thought...

See ya!