ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 377

SQL Statements A - D

DECLARE Variable

default value is longer than the target column, it is truncated.

• For a BINARY column, if the speciﬁed default value is shorter in length than the target

column, it is padded with zeroes. For a BINARY or VARBINARY column, if the speciﬁed

default value is longer than the target column, it is truncated.

Authorization

Anyone can use the DECLARE statement in a procedure.

Example

DECLARE input, output CHAR(80);

DECLARE nrows INTEGER;

DECLARE PartNumber CHAR(16) NOT NULL;