I am trying to create a Net Search Extender index on a table:
CREATE INDEX TXTINDX for text on TESTTBL (TEXTCOL) connect to SAMPLE";

This works fine if I run through the db2 command window, and use db2text .

What I really need to do though is create a number of indicies using JDBC. The regular (non-text extender) Create Index statements work fine. This one does not; I see syntax errors on the 'for' word.

Is it possible to create Net Search Extender indicies using a JDBC connection?

Thanks
Debbie