Session Variable

A (user defined) session variable is a context variable that can be used in streaming SQL. It can be set at run time using ALTER SESSION (for the current session) or ALTER PUMP (for one or more pumps and their associated sessions). The session variable can be used anywhere in a SQL statement where a literal is allowed.

For more information see User Defined Session Variables in the Basic Building Blocks section of the Streaming SQL Reference Guide.