HELP AGAIN ...

Posted in 2000

Topics: Error Codes & Troubleshooting, Server Administration

shahid.mehmood@aku.edu — Wed, 10 May 2000 17:29:24 +0500 — source: Informix-list mailing list archive (1991-1998)

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> 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 </BODY> </HTML> ------_=_NextPart_001_01BFBA7B.60541972--

↪ replying to shahid.mehmood@aku.edu

David Weis — Wed, 10 May 2000 11:22:14 -0400 — source: Informix-list mailing list archive (1991-1998)

shahid.mehmood@aku.edu wrote in message <8fbqvg$dar$1@news.xmission.com>... > >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. Sure, I can help you. :-) onstat -u will probably show a connection to the database......and ofCOURSE, no one will own up to having improperly shut down a window based terminal emulation program........ Anyway, you can either onmode -z sessionid# the connection or just bounce the engine to get rid of the orphan connection to the database. Then you should be able to perform your alter table. >btw: How should configure my MS-OUTLOOK, so that the message should not be >convered in MIME/HTML format? Click on Tools; then click on Options, then click on the Send tab; then click on Plain text for the News Sending Format. >Thanks in advance Your welcome in advance. Did you say advance? Oh, brother, a cash advance is always welcome!!!! >Shahid Mehmood >Software Designer II >Information Systems Department >The Aga Khan University >Karachi >Official:Y *snip* I deleted all the MINE/HTML stuff.......... David Weis, independent Informix DBA dweis@louisville-i-market.com Voice: 502-637-7316

↪ replying to shahid.mehmood@aku.edu

Art S. Kagel — Thu, 11 May 2000 11:43:24 -0400 — source: Informix-list mailing list archive (1991-1998)

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

Related threads

Glossary

ISAM error