1 CREATE-INDEX 2? index-schema-"." 3 index-name FOR TEXT ON 3? table-schema-"." 4 table-name 4 (text-column-name) 4? |function-schema "."| 4.1 function-name-(-text-column-name-) 5? |attribute-list| 6? |text-default-information| 7? |update-characteristics| 8? |storage-options| 9? |cache-search-result-options| 10? |index-configuration-options| 11? |connection-options| attribute list: 1 ATTRIBUTES ( 2+ ',' 2 SQL-column-expression 2.1? AS-attribute-name 2.1.1 ) text-default-information: 1? CCSID ccsid 2? LANGUAGE language 3? FORMAT format 3.1? |model-information| model-information: 1 DOCUMENTMODEL documentmodel-name IN modelfilepath 2? USING-CCSID ccsid update-characteristics: 1? UPDATE-FREQUENCY 1.1 NONE 1.1 |update-frequency| 2 |incremental-update-characteristics| 2 RECREATE INDEX ON UPDATE incremental-update-characteristics: 1? UPDATE-MINIMUM minchanges 2? REORGANIZE 2.1 AUTOMATIC 2.1 MANUAL 3? 3 COMMITCOUNT-FOR-UPDATE count 3 |capture-table-characteristics| capture-table-characteristics: 1 REPLICATION-CAPTURE-TABLE 2? capture-table-schema-"." 3 capture-table-name CONTROL TABLE SCHEMA capture-control-schema update-frequency: 1 D ( 2 * 2+ , 2 0...6 3 ) H ( 2 * 2+ , 2 0...23 3 ) M ( 2+ , 2 0...59 3 ) storage-options: 1? INDEX-DIRECTORY directory 2? WORK-DIRECTORY workdirectory 3? ADMINISTRATION-TABLES-IN tablespace-name cache-search-results-options: 1 CACHE TABLE ( 2+ ',' 2 SQL-column-expression 2.1? AS attribute-name 2.1.1 ) 2? 2 PERSISTENT 2.1? IN directory 2 TEMPORARY 3? PCTFREE percentage 4 MAXIMUM CACHE SIZE memsize 5? INITIAL SEARCH RESULT ORDER ( SQL-order-by-list ) 6? KEY COLUMNS FOR INDEX ON VIEW (SQL-columnname-list) index-configuration-options: 1 INDEX CONFIGURATION ( 2+ , 2 option-value 3 ) connection-options: 1 CONNECT-TO database-name 2? USER userid USING password