ODBC Server Reference Manual

CORE SQL Language

HP NonStop ODBC Server Reference Manual—429151-002

3-25

Expressions and Operators

For more information about search conditions, see the X/Open CAE Specification.

Expressions and Operators

Use CORE SQL syntax in expressions when using the NonStop ODBC Server.

The syntax of an expression is:

dynamic-parameter

is represented by a question mark (?); it identifies a parameter in a dynamically

prepared SQL statement

literal

is an exact representation of a numeric or character value.

USER

is a keyword that represents a character string containing a logical username.

The column-name is described under Names on page 3-3 and ODBC-scalar-

function-extension is described under Escape Clauses on page 3-11;

aggregate-function-reference is described under Aggregates on page 3-27.

operand [ arithmetic-operator operand

[ arithmetic-operator operand ] ... ]

operand is:

{ column-name }

{ dynamic-parameter }

{ literal }

{ ODBC-scalar-function-extension }

{ aggregate-function-reference }

{ USER) )

arithmetic-operator is:

( + }

{ – }

{ * }

{ / }