Name

att_local_name — Compose a fully qualified table name based on DSN and remote table name.

Synopsis

varchar att_local_name ( in dsn varchar ,
  in table varchar );
 

Description

The utility function, att_local_name() , can be used to make a fully qualified table name from non-qualified or qualified one, i.e. the qualifier and owner will be added if they are missing. The schema name will be replaced with current qualifier on execution, owner will be replaced or added with name of supplied DSN name. All non-alphanumeric characters in the name will be replaced with underscore symbol.

Parameters

dsn

The name of remote data source.

table

The name of remote table.

Return Types

A string will be returned containing the fully qualified table name.

Examples

Example 24.19. Using the att_local_name() function

This simple example shows retrieval of fully qualified table name. using the att_local_name() function from ISQL.

SQL> select att_local_name ('Oracle', 'DEMO.EMP');
callret
VARCHAR
_______________________________________________________________________________

DB.ORACLE.EMP

1 Rows. -- 9 msec.