could anyone tell me if there is a way to specify the tablespace
in which an index is created?
I tried this already:
CREATE UNIQUE INDEX IX_USR_ACCOUNT_1 ON USR_ACCOUNT ( NAME, DOMAIN ) IN USERSPACE8
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "IN" was found following ")". Expected tokens
may include: "". SQLSTATE=42601