RE: is this a problem?

> -----Original Message----- > From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org] > On Behalf Of Jonathan Leffler > Sent: Tuesday, April 26, 2005 12:20 AM > To: informix-list@iiug.org > Subject: Re: is this a problem? > > jda wrote: > > I have two tables in sysmaster:systabnames that have two records > each. > > I was thinking that there should only be one record per > tabname/dbsname > > combo, I'm I thinking wrong? If I'm right how do I correct this? > If, > > I'm wrong, what are the reasons for having two records? > > > > systabnames records for the two tables. > > > > partnum 2102365 > > dbsname cars > > owner informix > > tabname systabperm > > collate en_US.819 > > > > partnum 2102371 > > dbsname cars > > owner informix > > tabname systabperm > > collate en_US.819 > > > > partnum 2102819 > > dbsname cars > > owner informix > > tabname gu_prereg_pay > > collate en_US.819 > > > > partnum 2102821 > > dbsname cars > > owner informix > > tabname gu_prereg_pay > > collate en_US.819 > > Various questions spring to mind - such as which version of IDS, > running > on which platform... What does ON-Check have to say about the state > of > the instance and the database? > > The general answer to your question is "No, you should normally only > have one table of a given name in your database". [Bill Dare] I checked a few tables and I have one entry for each fragment with a different partnum. I suspect that is the case for the tables shown above. Regards, Bill > There are exceptions; > if your database is MODE ANSI, it is possible to have the same table > name with two different owners. Question: is the owner listed in > systabnames the database owner or the table owner? It really only > makes > sense for it to be the table owner - but the question should be asked. > > Are you messing with DELIMIDENT at any time? If so, you can achieve > interesting results with trailing blanks. > > If ON-Check doesn't identify anything wrong, have you tried connecting > > to the database and seeing what is in systables in the cars database? > > Depending what you find based on these investigations, there could be > numerous explanations, corresponding to numerous findings. However, > you > should probably not simply continue using the database without > determining what is going on. > > -- > Jonathan Leffler #include <disclaimer.h> > Email: jleffler@earthlink.net, jleffler@us.ibm.com > Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/ sending to informix-list