Re[2]: transaction log withOUT begin work
Hi Alan,
Thanks for your responds.
I think this is NOT MODE ANIS database. Also, I have checked owner of
table and its O.K. (show as proadm1). In addition, I try to unload
table from dbaccess using "unload to junk select * from table" sql
command, than middle of unloading process I get "Unknown error number
0" message.
But, today I ran dbaccess without anyone accessing database and I was
able to display status of table. And when I exit from dbaccess, I was
NOT getting "TRANSACTION: Commit Rollback" message. Any ideal what's
happening.
Also, we are using On-line 5.01.UD2 on Sequent ptx2.1.5 with third
parity application call Claims 2000 from Continuum (Pro Systems).
Thanks
Susik
______________________________ Reply Separator _________________________________
}Subject: Re: transaction log withOUT begin work
}Author: INTERNET:aland@informix.com at CSERVE
}Date: 8/29/96 3:53 AM
}
}
}Sender: informix-list-owner@rmy.emory.edu
}Received: from rmy.rmy.emory.edu (rmy.rmy.emory.edu [170.140.97.4]) by
}dub-img-2.compuserve.com (8.6.10/5.950515)
} id DAA20345; Thu, 29 Aug 1996 03:44:25 -0400
}Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id
}DAA11522 for susik_lee@united#u#group.ccmail.compuserve.com; Thu, 29 Aug 1996
}03:44:50 -0400 (EDT)
}From: aland@informix.com (Colonel Panic)
}Message-Id: <5034cr$b83@news.informix.com>
}Subject: Re: transaction log withOUT begin work
}Date: 29 Aug 1996 03:56:11 GMT
}Reply-To: aland@informix.com (Colonel Panic)
}Organization: Tools & Environments Technology Center, Informix Software, Inc.
}Sender: informix-list-owner@rmy.emory.edu
}To: informix-list@rmy.emory.edu
}X-Informix-List-To: susik_lee@united#u#group.ccmail.compuserve.com
}X-Informix-List-Id: <news.27531>
}
}In article <502btm$3gk@cssun.mathcs.emory.edu>,
} <Susik_Lee@United#u#Group.CCMAIL.CompuServe.COM> wrote:
}> I started dbaccess and selected table info to view status of table.
}> But it does not display any info about this table. So, when I try to
}> exit out of dbaccess, I get "TRANSACTION: Commit Rollback" message.
}> This happens to only few tables. Does anyone know why this is
}> happening.
}
}I suspect this occurs in a MODE ANSI database. Perhaps you aren't giving
}the proper owner name of the table, and/or are not careful to keep the
}upper/lower case of the owner name intact.
}
}
}
}--
}Alan Denney aland@informix.com I'm Pro-Anarchy... and I Vote!
}