Hi, Forum:
I successfully created my second Database and loaded several(6) instances.
Being happy with that, I’ve been trying to query the database, but it doesn’t return right results that I expect.
When I do this from TII XQuery,
for $t in input()
return $t
it returns 6 objects in the format of
xq:result/xq:object/TLTransaction
BUT, when I try this,
for $t in input()
return $t/ 
TLTransaction:cool:
it throws “8306:Invalid cursor position”.
Similar query works for the other database.
The only difference(that I can think of) of the “TLTransaction” Database is that it imports two other schemas(XMLSignature and XMLEncryption). I had defined both “Signature.tsd” and “Encryption.tsd” before I defined “TLTransaction.tsd”.
Here’s the beginning of my schema.
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema targetNamespace=“http://www.myCompany.com” xmlns:xs=“XML Schema” xmlns:tsd=“http://namespaces.softwareag.com/tamino/TaminoSchemaDefinition” xmlns:ds=“XML-Signature Syntax and Processing” xmlns:xenc=“XML Encryption Syntax and Processing” xmlns:tl=“http://www.myCompany.com” elementFormDefault=“qualified”>
xs:annotation
xs:appinfo
<tsd:schemaInfo name=“TLTransaction”>
<tsd:collection name=“TxnCollection”/>
<tsd:doctype name=“tl:TLTransaction”>
tsd:logical
tsd:contentclosed</tsd:content>
</tsd:logical>
</tsd:doctype>
</tsd:schemaInfo>
</xs:appinfo>
</xs:annotation>
<xs:import namespace=“XML-Signature Syntax and Processing” schemaLocation=“Signature”/>
<xs:import namespace=“XML Encryption Syntax and Processing” schemaLocation=“EncryptedData”/>
<xs:element name=“TLTransaction”>
xs:complexType
xs:sequence
<xs:element name=“Header” type=“tl:TransactionHeaderType”/>
<xs:element name=“Body” type=“tl:TransactionBodyType”/>
</xs:sequence>
</xs:complexType>
</xs:element>
…
Can somebody help with this?
Scott Chung
Never mind 
I self-solved this by declaring namespace like this.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
declare namespace tl= “http://www.myCompany.com”
for $q in input()/tl:TLTransaction
return $q
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Hmmm… so if there are several namespaces, we have to declare them when we query. I see.
Well…I am learning.
Scott