View Single Post

   
  #2 (permalink)  
Old 05-16-2008, 01:44 PM
Superboer
 
Posts: n/a
Default 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.


Reply With Quote