>>The table needs to be part of an DBC if you needt this syntax, for what I remember.
>
>it is part of a dbc
>
>but i cant find a way to create a regular index with the sql create table command
>I guess I have to issue a index on ... tag ... after the create
>

Correct, you can create primary keys, candidate keys, and foreign keys in CREATE TABLE. Other tags have to be added afterward.

Tamar