Declaring Variables In TOAD

Toad for IBM DB2
1

Dear community,

    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.

2

Hello,

Although IBM CLP Plus supports inline PL SQL scripts, the Toad Editor does not support it at this time. Are you attempting to run this command through Toad’s Editor?

3

Yes, that’s correct, just a one liner. Thanks for getting back me David. I really appreciate it.