Xquery declare namespace returns error

grofaty · #1 (**permalink**) 12-12-08, 07:30

Hi,
on DB2 v9.5 fp2 on Linux I would like to declare namespace in Xquery. I wrote the following code:

Code:

XQUERY declare namespace ns1="http://data.si.snt.eu"

But got the following error:

Code:

SQL16002N  An XQuery expression has an unexpected token
""http://data.si.snt.eu"" following "eclare namespace ns1". Expected tokens
may include: "<space>". Error QName=err:XPST0003.  SQLSTATE=10505

Any idea what is wrong with the code?
Regards

n_i · #2 (**permalink**) 12-12-08, 09:19

You cannot have a prolog without the query itself, I believe. Also, each prolog statement must be terminated by a semicolon.

Internet Services

Web Development

Digital Marketing

Consumer Tech