SEO

#1 (**permalink**) 05-16-2008, 01:44 PM

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.

#2 (**permalink**) 05-16-2008, 01:44 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Drop table with incorrect tablename