I am new to IBM DB2 and Toad is a lovely product, but I get frustrated by the fact that I cannot declare a variable as follows:
DECLARE PAY DECIMAL(15,2) DEFAULT (10000.00);
When I execute this code I get an error message as follows: Token DECIMAL was not valid. Valid tokens: DYNAMIC SENSITIVE ASENSITIVE INSENSITIVE.
Can anyone help please?
Thanks in advance.