Database Object Name

Use the Database Object Name segment to specify the name of a database object, such as a column, table, view, or user-defined routine. Use this segment whenever you see a reference to a database object name.

Syntax

Notes:

¹ HCL OneDB™ extension
² See Owner name


Element	Description	Restrictions	Syntax
database	Database where object resides	Must exist.	Database Name
dbservername	Database server of database	Must exist. No space after `@`.	Identifier
object	Name of a database object	See Usage.	Identifier

Usage

A database object name can include qualifiers and separator symbols to specify a database, a server, an owner, and (for some objects) another object of which the current database object is a component. For example, this expression specifies the unit-price column of the stock table, owned by user informix, in the stores_demo database of a database server called butler:

stores_demo@butler:informix.stock.unit_price

If you are creating or renaming a database object, the new name that you declare must be unique among objects of the same type in the database. Thus, the name of a new view must be unique among the names and synonyms of tables, views, and sequence objects that already exist in the same database. (But a view can have the same name as a view in a different database of the same server, or the same name as a trigger, for example, because these are different types of objects.)

In an ANSI-compliant database, the owner.object combination must be unique in the database for the type of object. A database object specification must include the owner name for a database object that you do not own. For example, if you specify a table that you do not own, you must also specify the owner of the table. The owner of all the system catalog tables is informix.

In HCL OneDB, the uniqueness requirement does not apply to the name of a user defined routine (UDR). For more information, see Routine Overloading and Routine Signatures.

Characters from the code set of your database locale are valid in database object names. For more information, see HCL OneDB GLS User's Guide.