Home | Previous Page | Next Page   Accessing and Modifying Data in an External Database > Accessing Other Database Servers >

Accessing ANSI Databases

In ANSI databases, the owner of the object is part of the object name: ownername.objectname. When both the current and external databases are ANSI databases, unless you are the owner of the object, you must include the owner name. The following SELECT statement shows a fully-qualified table name: 

SELECT name, number FROM salesdb@aserver:ownername.contacts

Tip:
You can always over-qualify an object name. That is, you can specify the full object name, database@servername:ownername.objectname, even in situations that do not require the full object name.

For more information about ANSI-compliant databases, refer to the IBM Informix: Database Design and Implementation Guide.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]