Toad World® Forums

Declaring Variables In TOAD

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.

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?

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