Name
complete_table_name — Returns a fully qualified table name.
Synopsis
varchar
complete_table_name
(
|
in tablename varchar , |
in
mode
integer
); |
Description
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.
Parameters
tablename
The table name to be retrieved.
mode
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 0.
When the mode parameter is 0 the result will be generated using the current qualifier and current SQL user account names.
Return Types
A string will be returned containing the fully qualified table name.
Errors
Table 24.11. Errors signalled by
| SQLState | Error Code | Error Text | Description |
|---|---|---|---|
| 22023 | SR014 | Function complete_table_name needs a string as argument 1, not an arg of type [type] | |
| 22023 | SR008 | Function complete_table_name needs an integer as argument 2, not an arg of type [type] |
Examples
Example 24.44. Using the complete_table_name() function
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:
SQL> use WS;
Done. -- 4 msec.
SQL> select complete_table_name('SYS_DAV_RES', 1);
callret
VARCHAR
_______________________________________________________________________________
WS.WS.SYS_DAV_RES
1 Rows. -- 1 msec.
SQL> select complete_table_name('SYS_DAV_RES__', 1);
callret
VARCHAR
_______________________________________________________________________________
WS.DBA.SYS_DAV_RES__
1 Rows. -- 1 msec.