Name
quote_dotted — Returns an quoted identifier.
Synopsis
varchar
quote_dotted
(
|
in dsn varchar , |
in
identifier
varchar
); |
Description
The
quote_dotted()
function will return the
identifier (table name or column name) appropriately quoted for the remote
data source. This function will obtain the appropriate quote characters
from the remote data source. This function can be used in conjunction with
rexecute function.
Parameters
dsn
The remote DSN name.
identifier
The string containing the identifier. The identifier can be a one, two or three part name, separated with the dot, '.', character.
Return Types
A string will be returned containing the quoted identifier.
Errors
Table 24.72. Errors signalled by
| SQLState | Error Code | Error Text | Description |
|---|---|---|---|
| 22023 | VD011 | Supplied DSN [name] is not valid |
Examples
Example 24.250. Using the quote_dotted() function
This simple example shows an identifier from a remote Oracle data source being correctly quoted using the quote_dotted() function from ISQL.
SQL> select quote_dotted ('oracle', 'DEMO.EMP');
callret
VARCHAR
_______________________________________________________________________________
"DEMO"."EMP"
1 Rows. -- 2 msec.