# Declaring Variables In TOAD

**URL:** <https://forums.toadworld.com/t/declaring-variables-in-toad/29491>\
**Category:** Toad for IBM DB2\
**Created:** [March 27, 2014, 3:32am UTC](https://forums.toadworld.com/t/declaring-variables-in-toad/29491 "2014-03-27T03:32:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![riccarddo](https://avatars.discourse-cdn.com/v4/letter/r/b5a626/32.png) [@riccarddo](https://forums.toadworld.com/u/riccarddo)\
**Post date:** [March 27, 2014, 3:32am UTC](https://forums.toadworld.com/t/declaring-variables-in-toad/29491/1 "2014-03-27T03:32:48Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![david.booher\_187](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/david.booher_187/32/129_2.png) [@david.booher\_187](https://forums.toadworld.com/u/david.booher_187)\
**Post date:** [March 31, 2014, 10:24am UTC](https://forums.toadworld.com/t/declaring-variables-in-toad/29491/2 "2014-03-31T10:24:31Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![riccarddo](https://avatars.discourse-cdn.com/v4/letter/r/b5a626/32.png) [@riccarddo](https://forums.toadworld.com/u/riccarddo)\
**Post date:** [April 1, 2014, 12:45am UTC](https://forums.toadworld.com/t/declaring-variables-in-toad/29491/3 "2014-04-01T00:45:40Z")

</div>

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