ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-13
Escape Clauses
Escape Clauses for Scalar Functions
When you include any scalar function (described under Functions on page 3-14) in a
CORE SQL statement, the escape clause used has the following format:
FN
specifies that what follows is the invocation of a scalar function.
For example, the following SELECT statement specifies that string values in the NAME
column are to be shifted to uppercase letters:
select {fn ucase(name)} from employee
Escape Clauses for Outer Joins
ODBC uses the following form of escape clause for specifying an outer join:
oj
specifies that what follows is an outer join specification.
For example, the following SELECT statement specifies a join condition between two
table references:
select employee.name,dept.deptname
from {oj employee left join dept
on employee.deptid=dept.deptid}
where employee.projid=544
--*( VENDOR(Microsoft), PRODUCT(ODBC) FN scalar-function )*--
or
{ FN scalar-function }
--*( VENDOR(Microsoft), PRODUCT(ODBC)
OJ table-reference LEFT [ OUTER ] JOIN table-reference
ON search-condition )*--
or
{ OJ table-reference LEFT [ OUTER ] JOIN table-reference
ON search-condition }