Specify user in sql statement

Posted in 2003

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/