Oninit cdi / Archive
Talk to an expert →

Tablename with leading blank

Posted in 2012

Topics: Server Administration, Migration, Import/Export & Data Conversion

WOLFGANG PFUELLER — — source: IIUG Forums & Mailing Lists

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

↪ replying to WOLFGANG PFUELLER
Fernando Nunes — — source: IIUG Forums & Mailing Lists

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

↪ replying to Fernando Nunes
Jack Parker — — source: IIUG Forums & Mailing Lists

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

↪ replying to WOLFGANG PFUELLER
Art Kagel — — source: IIUG Forums & Mailing Lists

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

↪ replying to Jack Parker
Art Kagel — — source: IIUG Forums & Mailing Lists

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

Related threads

Glossary