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. |