Здравствуйте,
подскажите пожалуйста как в DB2 выполнять математические операции в sql-скриптах.
Ниже представлен пример по умножению:

SELECT prod_id,
quantity,
item_price
quantity*item_price AS expanded_price
FROM OrderItems
WHERE order nam = 20008;
------------------------------------------------------------------------------
SELECT prod_id, quantity, item_price quantity*item_price AS expanded_price FROM OrderItems WHERE order nam = 20008
SQL0104N An unexpected token "*" was found following "item_price quantity".
Expected tokens may include: ",". SQLSTATE=42601

SQL0104N An unexpected token "*" was found following "item_price quantity". Expected tokens may include: ", ".

Explanation:

A syntax error in the SQL statement was detected at the specified
token following the text "<text>". The "<text>" field indicates
the 20 characters of the SQL statement that preceded the token
that is not valid.

As an aid to the programmer, a partial list of valid tokens is
provided in the SQLERRM field of the SQLCA as "<token-list>".
This list assumes the statement is correct to that point.

The statement cannot be processed.

User Response:

Examine and correct the statement in the area of the specified
token.

sqlcode : -104

sqlstate : 42601

получилось,
спасибо, Mark