Specify user in sql statement

Posted in 2003

Summary

S.P. Wiggers found that on a new 7.31 UD1 Solaris server queries had to give the table owner (username.items), unlike on the old server. Michael Krzepkowski asked if the database is in ANSI mode. Jonathan Leffler said selecting from systables as an ordinary user fails in a MODE ANSI database, and the only way to change mode is to recreate it, e.g. dbexport and dbimport.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Installation, Setup & Upgrades

S.P. wiggers — Mon, 7 Jul 2003 09:46:00 +0200 — source: Usenet: comp.databases.informix

Hello, The problem I have is since we have an extra server at our old server (installed by an external company) I used the sql-statement without specifying the user which created the table for example : select * from items But at our new server we need to specify te username which created the table for example: select * from 'username'.items Both server have the same version of informix installed : 7.31 UD1 on solaris Any Idea's ? I hope I don't have to reprogram all my applications.... thanx in advance Sander Wiggers (remove nospam from my e-mail address)

↪ replying to S.P. wiggers

Michael Krzepkowski — Mon, 07 Jul 2003 13:06:08 GMT — source: Usenet: comp.databases.informix

S.P. wiggers wrote: >Hello, >The problem I have is since we have an extra server > >at our old server (installed by an external company) I used the >sql-statement without specifying the user which created the table >for example : select * from items > >But at our new server we need to specify te username which created the table >for example: select * from 'username'.items > >Both server have the same version of informix installed : 7.31 UD1 on >solaris > >Any Idea's ? I hope I don't have to reprogram all my applications.... > > >thanx in advance > >Sander Wiggers (remove nospam from my e-mail address) > > > > Is your database by any chance in ANSI mode? HTH Michael

↪ replying to Michael Krzepkowski

S.P. wiggers — Tue, 8 Jul 2003 09:31:04 +0200 — source: Usenet: comp.databases.informix

I think it is, but i'm not sure, any idea how to check ? and if so is there an easy way to change it ? "Michael Krzepkowski" <NOmichaelkSPAM@sqlcanada.com> schreef in bericht news:3F09702A.3020208@sqlcanada.com... > S.P. wiggers wrote: > > >Hello, > >The problem I have is since we have an extra server > > > >at our old server (installed by an external company) I used the > >sql-statement without specifying the user which created the table > >for example : select * from items > > > >But at our new server we need to specify te username which created the table > >for example: select * from 'username'.items > > > >Both server have the same version of informix installed : 7.31 UD1 on > >solaris > > > >Any Idea's ? I hope I don't have to reprogram all my applications.... > > > > > >thanx in advance > > > >Sander Wiggers (remove nospam from my e-mail address) > > > > > > > > > Is your database by any chance in ANSI mode? > HTH > Michael >

↪ replying to S.P. wiggers

Jonathan Leffler — Tue, 08 Jul 2003 08:28:35 GMT — source: Usenet: comp.databases.informix

S.P. wiggers wrote: > I think it is, but i'm not sure, > > any idea how to check ? and if so is there an easy way to change it ? What happens if you (running as an ordinary user and not informix) say 'select tabname from systables where tabid = 1'? If it says no such table, you have a mode ansi database. There is no easy way to change a database from MODE ANSI to any other mode. Recreate from scratch - dbexport and dbimport is plausible. > "Michael Krzepkowski" <NOmichaelkSPAM@sqlcanada.com> schreef: >>S.P. wiggers wrote: >>>[...] >>> But at our new server we need to specify te username which >>> created the table for example: select * from 'username'.items >>>[...] >> >>Is your database by any chance in ANSI mode? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/