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.73. 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.

See Also

rexecute()