complete_table_name — Returns a fully qualified table name.
varchar complete_table_name (
in tablename varchar ,
in mode integer );
The complete_table_name() can be
used to make a fully qualified table name from non-qualified one,
i.e. the qualifier and owner will be added if they are missing.
The table name to be retrieved.
If this mode parameter is set to 1 this function will first
look-up the supplied tablename for a match in the system tables. If
a match is found the full name will be returned, if the table is
not found the function will continue as if the mode were set to
When the mode parameter is 0 the result will be generated using
the current qualifier and current SQL user account names.
A string will be returned containing the fully qualified table
Table 24.12. Errors signalled
Function complete_table_name needs a
string as argument 1, not an arg of type [type]
Function complete_table_name needs an
integer as argument 2, not an arg of type [type]
Example 24.44. Using the
This simple example shows retrieval of a fully qualified table
name using the complete_table_name() function from ISQL. In the
first case the table name supplied is a system table, in the second
case the table does not exist and the result is generated based on
the users details: