Lorenzo Fiorini wrote:

> When I issue CREATE INDEX "CDESDIS_DISHDR" ON "DISHDR"("CDESDIS") on the table created
> by the script below I get:
>
> Statement failed SQL code=-902 I/O error
> for file ""
> error while trying to open file no such file or directory

It does sound like a 'file too big' sort of problem. Smaller index and
few records work. How much space is left in both the partition where the
database is located, and the location of the temporary file - which may
be getting limited.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services