RE: What's wrong here?

If I go into STRSQL and run this:
values cast(15.2 - 2.1 as numeric(15,3))
it works.
Then I try F13
1. Change session attributes
Decimal point . . . . . . . . *comma
And try this
values cast(15.2 - 2.1 as numeric(15,3))
I get: SQL0104 Token ( was not valid. Valid tokens: ).
But if I try this:
values cast(15.2 - 2.1 as numeric(15, 3))
it works. It just looks funny to this Yank as:
VALUES
13,100

See also
RUNSQLSTM ... DECMPT(*PERIOD)
But it's best to just get into the habit of adding the space instead of relying upon adding stuff like DECMPT.



Rob Berendt