idxbuild reports SQL92 problem

[Gabor Topor]

Hi All,

After 4GL schema update we try running proutil idxbuild but it fails with the following error message:

"Index xxxxxxxxxx has a component with a not yet supported SQL92 datatype."

where xxxxxxxxxx is our index name.

I searched KBase without any success. (we tried in 9.1D and 9.1E too). Any idea?


Thanks,
Gabor

 

[tamhas]

Have you looked at the fields which comprise that index?

It is possible to create fields in the database using SQL statements that use datatypes which are not supported by ABL.

 

[TomBascom]

So, as Tamhas asks, what are the components of the index? Are you suggesting that the error message is wrong?

Also, you say "we tried in 9.1D and 9.1E too" so what version is the main problem occurring with?

 

[Gabor Topor]

Index definition looks like:

ADD INDEX "xxx ON "MyTable"
AREA "Schema Area"
UNIQUE
INACTIVE
INDEX-FIELD "f1" ASCENDING
INDEX-FIELD "f2" ASCENDING
INDEX-FIELD "f3" ASCENDING
INDEX-FIELD "f4" ASCENDING

where
f1, f1 , f3 are integer
anf f4 is decimal (FORMAT "->>>>>9.9<<<<<").


What is interesting after dump&load schema and data into a new DB everything works fine!!!

Thx,
Gabor

 

[Gabor Topor]

we tried 9.1D09 and 9.1E04 on AIX 5.2

 

[TomBascom]

Sounds like you had some sort of corruption.