TABLE_NAME

The TABLE_NAME function searches for an object and returns the unqualified name of the object after any alias chains have been resolved.

>>-TABLE_NAME(-object-name-+-------------------------------------+-)-><
                           '-, object-schema-+-----------------+-'     
                                             '-, location-name-'

The schema is DSN8.

The starting point of the resolution is the object that is specified by object-name and, if specified, object-schema and location name. If the starting point does not refer to an alias, the unqualified name of the starting point is returned. The resulting name can be of a table, view, or undefined object.

object-name: A character expression that specifies the unqualified name to be resolved. The unqualified name is usually of an existing alias. object-name must have a data type of VARCHAR and an actual length that is no greater than 18 bytes.
object-schema: A character expression that represents the schema that is used to qualify the value specified in object-name before resolution. object-schema must have a data type of VARCHAR and an actual length that is no greater than 8 bytes.
If object-schema is not specified or is null, the default schema is used for the qualifier.
location-name: A character expression that represents the location that is used to qualify the value specified in object-name before resolution. location-name must have a data type of VARCHAR and an actual length than is no greater than 16 bytes.
If location-name is not specified or is null, the location name is equivalent to "any".

The result of the function is VARCHAR(128). If object-name can be null, the result can be null; if object-name is null, the result is the null value.

The following table shows the external and specific names for TABLE_NAME. The specific names differ depending on the number of input arguments to the function.

Table 1. External and specific names for TABLE_NAME
Input arguments	External name	Specific name
object-name (VARCHAR)	DSN8DUTI	DSN8.DSN8DUTINV
object-name (VARCHAR) object-schema (VARCHAR)	DSN8DUTI	DSN8.DSN8DUTINVV
object-name (VARCHAR) object-schema (VARCHAR) location-name (VARCHAR)	DSN8DUTI	DSN8.DSN8DUTINVVV

Example: Assume that:

DSN8.VIEW_OF_SYSTABLES is a view of SYSIBM.SYSTABLES.
DSN8.ALIAS_OF_VIEW is an alias of DSN8.VIEW_OF_SYSTABLES.
The CURRENT SQLID is DSN8.

Use TABLE_NAME to find the name of the base object for ALIAS_OF_VIEW.

   VALUES DSN8.TABLE_NAME( 'ALIAS_OF_VIEW' );

The result of the function is 'VIEW_OF_SYSTABLES'.