Right-click on a table and choose Utility | Import Table. In the Command Options add a value for "Commit count." When running the script, Toad throws the following error:
Category Timestamp Duration Message Line Position
Error 4/23/2013 9:52:59 AM 0:00:04.134 <link> - SQL0104N An unexpected token "COMMITCOUNT" was found following "BY".
Expected tokens may include: "<filetype-modifier>". SQLSTATE=42601 1 0
WORKAROUND:
Copy the script to the editor and correct the syntax. The script should run by removing the "MODIFIED BY" clause after sending the generated script to the Editor.
STATUS:
Issue fixed in version 5.5. The latest version of Toad for DB2 can be downloaded at:
https://support.quest.com/
