Thanks alot Thomas, SQLStudio and dbmcli works (LoaderCli never used..)
bye ..GERD.. -----Urspr�ngliche Nachricht----- Von: Anhaus, Thomas [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 13. Januar 2004 09:10 An: 'Gerd K�nig' Betreff: RE: problem creating index Hi Gerd, I remember a problem with xsql concerning indexes, where the create index statement has been sent twice to the database kernel. Please try to create the index via another tool (SQLStudio, DBMCli, LoaderCli). *snip* Best Regards, Thomas -----Original Message----- From: Gerd K�nig [mailto:[EMAIL PROTECTED] Sent: Dienstag, 13. Januar 2004 09:05 To: SAPDB Mailinglist Subject: problem creating index Hi, I've a problem creating an index in our database. The tool xsql tells me, that the index already exists, but this isn't the case. have a look: ============================================================================ =================== linux:/opt/sapdb/depend/bin # xsql -d DBNAME -u USER,PASSWORD > select * from domain.indexes where tablename ='TAB_SHIPPINGSTATUS' OWNER | TABLENAME | INDEXNAME | TYPE | CREATEDATE | CREATETI | USER | TAB_SHIPPINGSTATUS | DATETIME | | 2030.11.22 | 00:11:22 | USER | TAB_SHIPPINGSTATUS | DISPONENT_ID | | 2030.11.22 | 00:11:22 | USER | TAB_SHIPPINGSTATUS | SHIPMENT_NUMBER | | 2030.11.22 | 00:11:22 | USER | TAB_SHIPPINGSTATUS | TOUR_ID | | 2030.11.22 | 00:11:22 | USER | TAB_SHIPPINGSTATUS | TYPE | | 2030.11.22 | 00:11:22 | * Ok > CREATE INDEX "SHIPPINGSTATUS_SHIPPER_ID" ON TAB_SHIPPINGSTATUS(SHIPPER_ID) * -6008: Duplicate index name > > quit ============================================================================ =================== I can't find the problem, so I hope that somebody knows the solution ;-) thanks ...GERD... -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
