# 22. Virtuoso Functions Guide - att_local_name

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
att_local_name
quote_dotted
rclose
rexecute
rmoreresults
rnext
rstmtexec
sql_columns
sql_config_data_sour...
sql_data_sources
sql_driver_connect
sql_get_installed_dr...
sql_get_private_prof...
sql_gettypeinfo
sql_primary_keys
sql_procedures
sql_remove_dsn_from_...
sql_special_columns
sql_statistics
sql_tables
sql_transact
sql_write_file_dsn
sql_write_private_pr...
vd_remote_data_sourc...
vd_remote_proc_wrapp...
vd_remote_table
vd_statistics
vdd_disconnect_data_...
vdd_measure_rpc_time
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## att_local_name

Compose a fully qualified table name based on DSN and remote table name.
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 execuation, owner will be replaced or added with name of supplied DSN name. All non-alphanumeric characters in the name will be replaced with undersore 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
Using the att_local_name() function

This simple example shows retrival 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.