Modifying the target data type by means of the CAST operator

In some cases, you can use the CAST operator (see section "CAST expression") to specify an appropriate target data type, even if SESAM/SQL determines a different data type internally.

Example

The following dynamic statement contains a two-digit operator with a placeholder (?).

UPDATE service SET vat=0.15+?

SESAM/SQL determines the data type of the placeholder for this two-digit operator from the data type of the other operator with NUMERIC(3,2). If the user wants a different data type, such as NUMERIC(4,2), he or she can use the CAST operator to specify this:

UPDATE service SET vat=CAST(? AS NUMERIC(4,2))