Tablename with leading blank
Wolfgang Pfueller got error -201 on dbexport (IDS 10.00.TC5) because of a table whose name began with a blank (owner.' 847'). Fernando Nunes suggested setting DELIMIDENT=yes and running DROP TABLE with quoted owner and name. Jack Parker suggested querying systables by tabid or tabname. Art Kagel suggested renaming under owner informix, then agreed on DELIMIDENT with double quotes. No outcome reported.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi,
when I try to export our database (dbexport) i get an error: -201 syntax error
occured. The database is 10.00TC5 and dbaccess shows a table with leading
blank in the tablename 'owner'. 847 . How can I delete this table?
Thanks
Are you sure you have a table with that name? How/why was it created?
In any case, set the environemtn variable DELIMIDENT=yes
and on dbaccess execute:
DROP TABLE "owner"." 847";
Regards
On Mon, Jun 11, 2012 at 1:35 PM, WOLFGANG PFUELLER <w.pfueller@saskia.de>wrote:
> Hi,
> when I try to export our database (dbexport) i get an error: -201 syntax
> error
> occured. The database is 10.00TC5 and dbaccess shows a table with leading
> blank in the tablename 'owner'. 847 . How can I delete this table?
>
> Thanks
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--20cf303a2c0f51057704c231b95b
Look at systables.
select * from systables where tabid=3D847
failing that:
select * from systables where tabname =3D' 847'
What does that say?
j.
On Jun 11, 2012, at 8:45 AM, Fernando Nunes wrote:
> Are you sure you have a table with that name? How/why was it created?=20=
>=20
> In any case, set the environemtn variable DELIMIDENT=3Dyes=20
> and on dbaccess execute:=20
>=20
> DROP TABLE "owner"." 847";=20
>=20
> Regards=20
>=20
> On Mon, Jun 11, 2012 at 1:35 PM, WOLFGANG PFUELLER=20
> <w.pfueller@saskia.de>wrote:=20
>=20
>> Hi,=20
>> when I try to export our database (dbexport) i get an error: -201 =
syntax=20
>> error=20
>> occured. The database is 10.00TC5 and dbaccess shows a table with =
leading=20
>> blank in the tablename 'owner'. 847 . How can I delete this table?=20
>>=20
>> Thanks=20
>>=20
>>=20
>>=20
>>=20
> =
**************************************************************************=
*****=20
>> Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>>=20
>>=20
>=20
> --=20
> Fernando Nunes=20
> Portugal=20
>=20
> http://informix-technology.blogspot.com=20
> My email works... but I don't check it frequently...=20
>=20
> --20cf303a2c0f51057704c231b95b=20
>=20
>=20
> =
**************************************************************************=
*****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>=20
Try renaming the table without using the owner on the old name but
specifying a new owner of "informix" as part of the new name.
Art
On Jun 11, 2012 8:36 AM, "WOLFGANG PFUELLER" <w.pfueller@saskia.de> wrote:
> Hi,
> when I try to export our database (dbexport) i get an error: -201 syntax
> error
> occured. The database is 10.00TC5 and dbaccess shows a table with leading
> blank in the tablename 'owner'. 847 . How can I delete this table?
>
> Thanks
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae93403f52622ee04c2323e6e
Oops misunderstood. Set DELIMIDENT=1 in your environment, then use double
quotes to specify the tableau in a drop or rename statement.
Art
On Jun 11, 2012 8:51 AM, "Jack Parker" <jack.parker4@verizon.net> wrote:
> Look at systables.
>
> select * from systables where tabid=3D847>
> failing that:
>
> select * from systables where tabname =3D' 847'>
> What does that say?
>
> j.
>
> On Jun 11, 2012, at 8:45 AM, Fernando Nunes wrote:
>
> > Are you sure you have a table with that name? How/why was it created?=20=
>
> >=20
> > In any case, set the environemtn variable DELIMIDENT=3Dyes=20
> > and on dbaccess execute:=20
> >=20
> > DROP TABLE "owner"." 847";=20
> >=20
> > Regards=20
> >=20
> > On Mon, Jun 11, 2012 at 1:35 PM, WOLFGANG PFUELLER=20
> > <w.pfueller@saskia.de>wrote:=20
> >=20
> >> Hi,=20
> >> when I try to export our database (dbexport) i get an error: -201 =
> syntax=20
> >> error=20
> >> occured. The database is 10.00TC5 and dbaccess shows a table with =
> leading=20
> >> blank in the tablename 'owner'. 847 . How can I delete this table?=20
> >>=20
> >> Thanks=20
> >>=20
> >>=20
> >>=20
> >>=20
> > =
> **************************************************************************=
> *****=20
> >> Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>
> >>=20
> >>=20
> >=20
> > --=20
> > Fernando Nunes=20
> > Portugal=20
> >=20
> > http://informix-technology.blogspot.com=20
> > My email works... but I don't check it frequently...=20
> >=20
> > --20cf303a2c0f51057704c231b95b=20
> >=20
> >=20
> > =
> **************************************************************************=
> *****=20
> > Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>
> >=20
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae9340e1b5b905e04c2324794