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
Table24.73.Errors signalled by
| SQLState | Error Code | Error Text | Description |
|---|---|---|---|
| 22023 | VD011 | Supplied DSN [name] is not valid |
Examples
Example24.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.