col1 = '123'

Character constants must be enclosed in single quotation marks and not exceed 255 characters in length.
Binary constants must be enclosed in single quotation marks and preceded by “X,” for example, X'00'.
Numeric constants can be specified with an optional leading sign and decimal point. Exponential floating point format is allowed.

A numeric operand can be compared only with another numeric operand.
A character operand can be compared with either a character or binary operand.
A binary operand can be compared with either a character or binary operand.
Date, time and timestamp (date-time) operands can be compared only with an identical column type or a character constant in the correct format. For dates and timestamps, the year value must be in the valid range of years that is set by the DATERANGE statement in the DBMOVER configuration file.

DATE
YYYY
-
MM
-
DD
Single-digit
DD
and
MM
values are allowed. If the lower order portion of the date is omitted, it defaults to the values specified as the
Data Defaults
within the data map.
TIME
HH
.
MI
.
SS
Single-digit
HH
,
MI
, and
SS
values are also allowed. If the lower order portion of the time is omitted it defaults to the following values:
MI
=00,
SS
=00.
TIMESTAMP
YYYY
-
MM
-
DD
HH
.
MI
.
SS
.
NNNNNN
The
NNNNNN
value is the fractional seconds value. Single digits are allowed for
DD
,
MM
,
HH
,
MI
,
SS
, and
NNNNNN
. The date and time values default to the following values:
MI
=00,
SS
=00,
HH
=00,
NNNNNN
=000000.
You can enter only the date or only the time component with the other component defaulting. If insufficient information is available to deduce which component has been entered, it will be assumed to be the date component.