SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Language Elements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
6-105
Pseudocolumns
Pseudocolumns
A pseudocolumn is a virtual column, which behaves like a table column. You can only
select values from a pseudocolumn. You cannot insert, update, or delete values from a
pseudocolumn. User queries can access the values from a sequence generator using the fol-
lowing pseudocolumns:
•
CURRVAL, which returns the current value in the sequence
•
NEXTVAL, which returns the next value in the sequence
sequence
specifies the ANSI name of the sequence generator.
sequence.CURRVAL | sequence.NEXTVAL