請問下列寫法是否有誤,其正確寫法為何?謝謝!
/hinet/exe/db>pg bb.sh
dbaccess boss1 -<<!
create unique index "informix".phntel_1 on "informix".phntel (usrid,bilym) fragment
by round robin in dbs07,dbs08;
create index "informix".phntel_2 on "informix".phntel (payid,bilym) fragment byround
robin in dbs09,dbs10;
update statistics for table phntel;
!
exit

上述shell script執行會有下列錯誤
sun63:/hinet/exe/db>bb.sh

Database selected.


201: A syntax error has occurred.
Error in line 1
Near character position 112

201: A syntax error has occurred.
Error in line 1
Near character position 105

Statistics updated.



Database closed.

只有 table 才能透過 round robin 的方式做 fragment，
如果是 index 的話，只能使用 by expression 的方式。
例如：
CREATE UNIQUE INDEX "informix".phntel_1 ON "informix".phntel( usrid, bilym )
FRAGMENT BY EXPRESSION usrid < 1000 IN dbs07, usrid >= 1000 IN dbs08;
請參考。