RE: HELP AGAIN ...

Posted in 2000

Topics: Error Codes & Troubleshooting, Server Administration, Security, Permissions & Auditing

shahid.mehmood@aku.edu — Fri, 12 May 2000 09:24:48 +0500 — source: Informix-list mailing list archive (1991-1998)

No, it is not synonym or view! it is definitely a table, here is the schema of the table ... { TABLE "libdba".bcopy row size = 259 number of columns = 27 index size = 177 } create table "libdba".bcopy ( bcopycode char(10), active char(1), bookcode char(20), orderno char(10), entrydate date, donorcode char(10), donorurn smallint, pages smallint, edition char(3), volume char(3), binding char(1), bstatcode char(10), locationcode char(10), btypecode char(10), currency char(15), price decimal(10,2), purch_price decimal(10,2), purch_date date, vouchercode char(10), gifted char(1), giftedby char(30), issued char(1), amt_recovered decimal(10,2), customercode char(10), remark char(60), systemdate datetime year to minute, findate datetime year to minute ); revoke all on "libdba".bcopy from "public"; create index "libdba".ix195_3 on "libdba".bcopy (bookcode); create unique index "libdba".ix195_1 on "libdba".bcopy (bcopycode); create index "libdba".ix195_4 on "libdba".bcopy (orderno); create index "libdba".ix195_9 on "libdba".bcopy (bstatcode); create index "libdba".ix195_10 on "libdba".bcopy (locationcode); create index "libdba".ix195_11 on "libdba".bcopy (btypecode); create index "libdba".ix195_5 on "libdba".bcopy (donorcode,donorurn); create index "libdba".ix291_5 on "libdba".bcopy (entrydate); Shahid Mehmood Software Designer II Information Systems Department The Aga Khan University Karachi Official:Y > -----Original Message----- > From: Art S. Kagel [SMTP:kagel@bloomberg.net] > Sent: Thursday, May 11, 2000 20:43 > To: informix-list@iiug.org > Subject: Re: HELP AGAIN ... > > Is it possible that the table bcopy is actually a synonym or view? That > might explain the error. > > Art S. Kagel > > shahid.mehmood@aku.edu wrote: > > > This message is in MIME format. Since your mail reader does not > understand > > this format, some or all of this message may not be legible. > > > > ------_=_NextPart_001_01BFBA7B.60541972 > > Content-Type: text/plain > > > > OS: SCO OPEN SERVER 5.0 > > OWS: INFORMIX OWS 7.2 > > > > When I try to alter a table, i get following error: > > > > the query: > > ALTER TABLE bcopy > > ADD (vendorcode CHAR(5) BEFORE edition )> > > > the error: > > 242: Could not open database table (libdba.bcopy). > > 106: ISAM error: non-exclusive access.> > > > Please note that nobody is using this table, or connected to this table. > > Can any one help me. > > > > btw: How should configure my MS-OUTLOOK, so that the message should not > be > > convered in MIME/HTML format? > > > > Thanks in advance > > > > Shahid Mehmood > > Software Designer II > > Information Systems Department > > The Aga Khan University > > Karachi > > Official:Y > > > > ------_=_NextPart_001_01BFBA7B.60541972 > > Content-Type: text/html > > Content-Transfer-Encoding: quoted-printable > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > > <HTML> > > <HEAD> > > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > > charset=3DUS-ASCII"> > > <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = > > 5.5.2650.12"> > > <TITLE>HELP AGAIN ...</TITLE> > > </HEAD> > > <BODY> > > > > > MS">OS:     SCO OPEN SERVER 5.0 > > > MS">OWS:    INFORMIX OWS 7.2 > > > > > > When I try = > > to alter a table, i get following error: > > > > > > the = > > query: > > ALTER TABLE > = > > bcopy > > ADD = > > (vendorcode CHAR(5) BEFORE edition ) > > > > > > the = > > error: > > > MS">   242: Could not open database table = > > (libdba.bcopy). > > > MS">   106: ISAM error:  non-exclusive access. > > > > > > Please note = > > that nobody is using this table, or connected to this table. > > Can any one > = > > help me. > > > > > > btw: How = > > should configure my MS-OUTLOOK, so that the message should not be = > > convered in MIME/HTML format? > > > > > > Thanks in = > > advance > > > > > > Shahid Mehmood > > Software Designer II > > Information Systems = > > Department > > The Aga Khan = > > University > > Karachi > > Official:Y > > > > > > > > </BODY> > > </HTML> > > ------_=_NextPart_001_01BFBA7B.60541972--

↪ replying to shahid.mehmood@aku.edu

David Williams — Fri, 12 May 2000 22:05:46 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <8fg29u$2aa$1@news.xmission.com>, shahid.mehmood@aku.edu writes > >No, it is not synonym or view! it is definitely a table, here is the schema >of the table ... Try onstat - Is the server On-line and not in Fast Recovery? onstat -g ath are there any sqlexec threads? is not what does onstat -g ath give? -- David Williams

Related threads

Glossary

ISAM error