# Statement delimiter

**URL:** <https://forums.toadworld.com/t/statement-delimiter/60611>\
**Category:** Toad for IBM DB2\
**Created:** [February 20, 2025, 9:57am UTC](https://forums.toadworld.com/t/statement-delimiter/60611 "2025-02-20T09:57:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![patrick.verboom](https://avatars.discourse-cdn.com/v4/letter/p/e56c9b/32.png) [@patrick.verboom](https://forums.toadworld.com/u/patrick.verboom)\
**Post date:** [February 20, 2025, 9:57am UTC](https://forums.toadworld.com/t/statement-delimiter/60611/1 "2025-02-20T09:57:59Z")

</div>

Hello. I use Toad for db2 version 7.4.1.12. In the options I can change the statement delimiter from the default ";" to for example the "@".  
Question is, does a toad command (to use in the editor) exist to change it in the script file itself?  
Reason: until now I used dbVisualizer to install stored procedures. I there needed the statement delimiter @ because otherwise the dbVisualizer tool recognised each statement of the procedure as a separate sql statement, which is not good.  
In dbVisualizer itself, I used the following command:

@delimiter @; -- ending with ; because default delimiter still is the ;

Thank you for helping me, because I cannot find it anywhere, so it might not exist?
