I am using Toad for DB2 v184.108.40.2062 and experiencing a sporadic error when trying to export a result set.
I run an SQL query and receive a result set that I wish to export; I highlight all the cells in the result window and “right click”. I then follow the navigation: Quick Export >> Excel Instance >> Excel Instance…
This used to work as expected for all SQL queries I currently run: a MicroSoft Excel sheet would open and the result set appeared on the Excel sheet.
Now this functionality does not seem to work for particular queries: a Microsoft Excel sheet opens, the column headings are populated; and then … nothing else populates. When I navigate back to TOAD window; I see the following error: Specified cast is not valid.
I cannot seem to find any connection between the exports that used to work as expected and the exports that now do not work; other than I have recently upgraded from the TOAD “freeware” version 4.6.xxx to the commercial version 220.127.116.112. i.e. I purchased the full licensed version.
Has anyone else experienced similar issues when using the Quick Export functionality ?
I can get around the above problem by simply following the same steps and instead of choosing: Quick Export >> Excel Instance >> Excel Instance… ; I simply follow the Quick Export >> File>> Excel File…
So it seems that TOAD can export the results into an excel file but cannot export them to an excel instance …again…this only fails on certain SQLs.
Thanks for any suggestions that are out there.
I have attached examples of an SQL that has no issues with either method and one that has now started failing when exporting to an Excel instance but is successful when exporting to an Excel file.
exports no issues.txt (431 Bytes)
fails export excel instance TOAD log.txt (969 Bytes)
fails export excel instance.txt (3.54 KB)