user_ind_columns strange format
From: murat <myildiz_at_fenerbahce.com>
Date: 21 Jan 2003 09:15:04 -0800
Message-ID: <d7b3b5c.0301210915.3dc543e4_at_posting.google.com>
;
If I query the user_ind_columns I get this :
Date: 21 Jan 2003 09:15:04 -0800
Message-ID: <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 Tue Jan 21 2003 - 18:15:04 CET