RE: Problem with Alter Index
If the index in question is generated by Informix, there will be a leading
space on the index name. This situation may be causing the problems that
you mentioned.
John Carlson
Informix DBA
EDS - WHSmith USA
3200 Windy Hill Road, Suite 1500 West
Atlanta, GA 30330
> -----Original Message-----
> From: diwesh sahai [mailto:diweshs@yahoo.com]
> Sent: Thursday, August 03, 2000 10:48 AM
> To: informix-list@iiug.org
> Subject: Problem with Alter Index
>
>
> Hi All,
> I basically want to delete unwanted chunks from the Informix
> database (
> sysmaster table )
> I'm trying to use Alter Index to do this.
>
> I'm facing a small problem here.
> Alter Index works fine if the index names start with a alphabet (ex:
> arc_req)
> But, if the index names start with a letter ( say 155_8 )> then it says
> " Syntax error".
>
> Can anyone help me out in this ?
>
> TIA
>
>
>
>