Values and Value Expressions › Special Registers

Special Registers

A special register is a system-supplied variable defined by CA IDMS. At any given time, the value of a special register depends upon the context of the current user session.

Usage

You use special registers in place of literals primarily in SQL data manipulation statements. For example, in the following SELECT statement, the special register CURRENT DATE specifies the end of a range of dates used as a selection criterion:

select emp_id, emp_lname
   from employee
   where start_date between '1989-01-01' and current date;