Re: Relation of OS user to Informix database user

Posted in 2005

Colin Dawson — Thu, 25 Aug 2005 10:14:52 +0000 — source: Usenet: comp.databases.informix

This is from the -310 SQL errror code. Only one table with a given name can exist in a single database. (In an ANSI-compliant database, the name of the user that created a table name qualifies it, so one table of a given name per user can exist.) Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: anupam.mukherjee@gmail.com >Reply-To: anupam.mukherjee@gmail.com >To: informix-list@iiug.org >Subject: Re: Relation of OS user to Informix database user >Date: 24 Aug 2005 23:22:39 -0700 > >Thanks for the great pointers. Sorry I'm a bit of a newbie and >hopefully my questions were not too basic. I did try reading up and >googling but could not find much. I have one more question . Is it at >all possible to create two different tables with the same name in the >same database but under two different users? sending to informix-list