XML Extender

[qyllr]

hello,

i am trying to enable the XML extender by running the following command:

dxxadm enable_db DATABASE;

but i keep getting the following error:

SQL0104N An unexpected token "enable_db" was found following
&quot;dxxadm &quot;. Expected tokens may include: &quot;JOIN <joined_table>
&quot;.

Explanation:

A syntax error in the SQL statement was detected at the specified
token following the text &quot;<text>&quot;. The &quot;<text>&quot; field indicates
the 20 characters of the SQL statement that preceded the token
that is not valid.

As an aid to the programmer, a partial list of valid tokens is
provided in the SQLERRM field of the SQLCA as &quot;<token-list>&quot;.
This list assumes the statement is correct to that point.

The statement cannot be processed.

User Response:

Examine and correct the statement in the area of the specified
token.

sqlcode : -104

sqlstate : 42601

any help will be greatly appreciated...

thanks,
q.

 

[qyllr]

thanks anyway...

i found the solution...

dxxadm is not a sql script... it's a batch file in c:\Program File\SQLLIB\BIN... i was running it in the db2 command line... it should have been executed under .cmd.

thanks,
q.