Re: user_ind_columns strange format

This is because a descending index is treated as a function-based index, as can be seen from user_indexes.index_type. Not sure if the format in this column will change in the future. You will need to cross reference user_ind_expressions to get the column name, looks like.

• Jusung Yang

myildiz_at_fenerbahce.com (murat) wrote in message news:<d7b3b5c.0301210915.3dc543e4_at_posting.google.com>...
> Hi,
> I have the index :
> create unique index index3 on wels (
> firmnr,
> liwerk,
> liefnr,
> ruelfd,
> liedat,
> liezei,
> lienul,
> liepos desc,
> lswerk,
> bestnr,
> bestpo
> ) STORAGE ( INITIAL 10K NEXT 1K PCTINCREASE 5 ) TABLESPACE
> indextbs
> ;
> If I query the user_ind_columns I get this :
>
> INDEX_NAME TABLE_NAME COLUMN_NAME
> INDEX3 TABLE FIRMNR
> INDEX3 TABLE LIWERK
> INDEX3 TABLE LIEFNR
> INDEX3 TABLE RUELFD
> INDEX3 TABLE LIEDAT
> INDEX3 TABLE LIEZEI
> INDEX3 TABLE LIENUL
> INDEX3 TABLE SYS_NC00083$
> INDEX3 TABLE LSWERK
> INDEX3 TABLE BESTNR
>
> And I have difficulties with my ODBC Connections.Can anyone explain
> why the columname is SYS_NC00083$?
>
>
> Murat
Received on Wed Jan 22 2003 - 01:43:36 CET