AW: Drop table with incorrect tablename
Hello Superboer,
> export DELIMIDENT=y
yes, that's it. Even selects are possible now. Thank' s a lot.
Reinhard.
> -----Ursprüngliche Nachricht-----
> Von: informix-list-bounces@iiug.org
> [mailto:informix-list-bounces@iiug.org]Im Auftrag von Superboer
> Gesendet am: Donnerstag, 15. Mai 2008 16:12
> An: informix-list@iiug.org
> Betreff: Re: Drop table with incorrect tablename
>
> Hello Reinhard.
>
> afaikr:
>
> export DELIMIDENT=y
>
>
> try:
>
> drop table "rv-extern";
>
> Superboer.
>
>
> On 15 mei, 15:26, "Habichtsberg, Reinhard" <RHabichtsb...@arz-
> emmendingen.de> wrote:
> > Hi all,
> >
> > I want to drop a table with an incorrect tablename.
> >
> > >From systables:
> >
> > tabname rv-extern
> > owner arcisadm
> > partnum 10486210
> > tabid 2507
> > rowsize 12
> > ncols 1
> > nindexes 0
> > nrows 14915
> > created 08.08.2003
> > version 164298765
> > tabtype T
> > locklevel P
> > npused 119
> > fextsize 16
> > nextsize 16
> > flags 0
> >
> > drop table rv-extern; # Syntax Error 201> >
> > Problem is the "-" (hyphen). Objectnames must start with a
> letter or "_" and
> > contain letters, digits, or "_".
> >
> > Don't know how the table was created. How can I drop that table?
> >
> > IDS 9.40.FC9W2.
> >
> > TIA,
> > Reinhard.
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>