>>hi everyone im new to this xml stuff and have some degree of trouble with it i was wondering if its possible to take a xsd file and make it into a cursor.

Generally speaking, it would have to be a very, very simple XSD to make the XSD into a cursor <s>.

Unless you're saying "I want to take the structure DESCRIBED BY THE XSD (not the XSD itself) and express that data structure as a cursor"?

IOW, the XSD is metadata. Think of it as the contents of AFIELDS(), except a lot better. Or maybe think about it as the contents of the DBC, including your stored procedures, rules and triggers. It's *METADATA*.

As a result, moving the XSD directly into a cursor would end up looking something like, well, the DBC, or the results of COPY STRUCTURE EXTENDED -- which I don't think it what you want.


I think what you probably want is the results of CREATE FROM ARRAY or CREATE FROM (where the source is the STRUCTURE EXTENDED table).

However, what you really need is potentially many (related) cursors. IOW there is no guarantee that your XSD is designed to produce a simple table structure. In fact, there is no guarantee that your XSD is designed to produce XML that looks anything like tables <s>.

It's quite possible that you could use your XSD to produce an XMLAdapter. There are a couple of different ways to do this. The best way -- and whether it is possible at all -- would depend on what your XSD actually looks like.

Maybe if you described what you are really trying to do a little better I could give you more advice that would make sense in your situation <s>.

>L<