Trying to do an update delete query i get :
<ino:response xmlns:ino=“http://namespaces.softwareag.com/tamino/response2” xmlns:xql=“XQL FAQ (XML Query Language - Frequently Asked Questions)”>
<xq:query xmlns:xq=“http://namespaces.softwareag.com/tamino/XQuery/result”>
<![CDATA[ update delete input()/AccessList
]]>
</xq:query>
<ino:message ino:returnvalue=“8552”>
<ino:messagetext ino:code=“INOXME8552”>Not a valid request</ino:messagetext>
ino:messagelineIt is not possible to open a cursor with XQuery Update Request.</ino:messageline>
</ino:message>
</ino:response>
Instead the query input()/AccessList works fine.
No other application are locking the file into collection i want to delete.
I tried also to shutdown the db or restarting the system.
Please, help me.
@nto
If you use TII to perform XQuery-Update’s, then blank out the “Pos. in Result” and “Result Size” boxes. If you don’t the request will be issued within the context of a cursor and for XQuery-Update this is not valid.
I don’t think you can do XQuery-Update to delete whole documents, I believe you get an error if you try. If you wish to delete whole documents then use _delete=AccessList. Otherwise XQuery-Update is fine for deleting partial nodes from document(s).
Hope this helps.
Stuart Fyffe-Collins
Software AG (UK) Ltd.