Specify user in sql statement

Specify user in sql statement

Post by S.P. wigger » Tue, 08 Jul 2003 16:46:00



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)

 
 
 

Specify user in sql statement

Post by Michael Krzepkowsk » Tue, 08 Jul 2003 22:06:08



>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

 
 
 

Specify user in sql statement

Post by ramesh.vasude.. » Wed, 09 Jul 2003 01:37:01


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"                                                                                                  

                      lcon.be>                 cc:                                                                                    
                      Sent by:                 Subject:  Specify user in sql statement                                                
                      owner-informix-li                                                                                                

                      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

 
 
 

Specify user in sql statement

Post by S.P. wigger » Wed, 09 Jul 2003 16:31:04


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 ?




> >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

 
 
 

Specify user in sql statement

Post by Jonathan Leffle » Wed, 09 Jul 2003 17:28:35



> 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.



>>>[...]
>>> 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>

Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
 
 
 

1. How to specify Exclusive ROWLOCK in SQL statements?

What do you mean by exclusive?  If your updating it no one else can modify
it either.  If your talking about selects then you may want to look at
UPDLOCK, HOLDLOCK and or SERIALIZABLE in BooksOnLine.

--
Andrew J. Kelly,  SQL Server MVP
TargitInteractive

Please join me at PASS North America in Denver - the first and only user
conference dedicated to SQL Server.
http://www.sqlpass.org/events/denverjan/index.cfm


2. "I'VE MADE OVER $100,000 ON THE NET"

3. HOW DO I: specify the no of records to return in a SELECT statement

4. Help! Importing data from external sites using DTS

5. new column specifying row number from select statement?

6. ComboBox using ADO with two fields in list.

7. Specifying Measure in Two Dimensional MDX Statement

8. Grouping records and page breaks (FMP 4)

9. How to specify SET in WHERE clause of MDX statement

10. Specify Datatype in Select Statement?

11. Specifying an INDEX in a SELECT statement

12. Help: Specifying a user account when a DTS Package is run via ASP

13. The specified user does not exist