Re: Specify user in sql statement

Sir: Please check the database logging. If the database logging mode is "ANSI", then you need to specify the object name with owner in quotes. The databases with No Logging, UN/Buffered logging are not having this constraint. Thank You Ramesh Vasudevan ."Never, ever, ever, ever, ever, ever, ever, give up. Never give up. Never give up. Never give up." - Winston Churchill "S.P. wiggers" <sander@nospam.fa To: informix-list@iiug.org lcon.be> cc: Sent by: Subject: Specify user in sql statement owner-informix-li st@iiug.org 07/07/03 03:46 AM Please respond to "S.P. wiggers" 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) sending to informix-list