A variable that you declare as a built-in SQL data type
can hold a value retrieved from a column of that built-in type. You
can declare an SPL variable as most built-in types, except BIGSERIAL,
SERIAL, and SERIAL8, as the following figure illustrates.Figure 1: Built-in
type variables.
DEFINE x INT;
DEFINE y INT8;
DEFINE name CHAR(15);
DEFINE this_day DATETIME YEAR TO DAY;
You can declare SPL variables of appropriate integer
data types (such as BIGINT, INT, or INT8) to store the values of serial
columns or of sequence objects.