# Idea Pond

**URL:** https://forums.toadworld.com/c/toad-for-ibm-db2/idea-pond/74.md

[Latest](https://forums.toadworld.com/latest.md) · [Categories](https://forums.toadworld.com/categories.md)

---

## [About the Idea Pond](https://forums.toadworld.com/t/about-the-idea-pond/41813)

<div class="topic-metadata">

**Author:** [@Jeff\_Podlasek](https://forums.toadworld.com/u/Jeff_Podlasek)\
**Replies:** 0\
**Last updated:** [September 6, 2018, 8:17pm UTC](https://forums.toadworld.com/t/about-the-idea-pond/41813 "2018-09-06T20:17:16Z")

</div>

Idea Pond is where you can submit new product enhancement ideas to the development team, and vote on ideas submitted by others. So, you have an idea to improve or add a feature? Great - we want to hear it! See an exist…

---

## [SSL Connections not working when a database is cataloged](https://forums.toadworld.com/t/ssl-connections-not-working-when-a-database-is-cataloged/60911)

<div class="topic-metadata">

**Author:** [@armando.reyes](https://forums.toadworld.com/u/armando.reyes)\
**Replies:** 0\
**Last updated:** [May 2, 2025, 4:39pm UTC](https://forums.toadworld.com/t/ssl-connections-not-working-when-a-database-is-cataloged/60911 "2025-05-02T16:39:35Z")

</div>

Only Connection string works, it seems that either Toad cannot read the catalog properly or the DB2 client is not properly configured. Can you enable an option like a checkbox to enable or enforce secure connection in T…

---

## [DB2 on IBM cloud requires an SSL connection](https://forums.toadworld.com/t/db2-on-ibm-cloud-requires-an-ssl-connection/47416)

<div class="topic-metadata">

**Author:** [@mwilcox1](https://forums.toadworld.com/u/mwilcox1)\
**Replies:** 6\
**Last updated:** [May 2, 2025, 4:16pm UTC](https://forums.toadworld.com/t/db2-on-ibm-cloud-requires-an-ssl-connection/47416 "2025-05-02T16:16:43Z")

</div>

We need to connect Toad Data Point to a Db2 service running on the IBM cloud. The DB2 service requires an SSL connection. Any ideas on how we can enable Toad to connect via SSL to my Db2 service ? Thank you

---

## [Migrate Toad z/OS Components tables from non-UTS to UTS tablespaces](https://forums.toadworld.com/t/migrate-toad-z-os-components-tables-from-non-uts-to-uts-tablespaces/58856)

<div class="topic-metadata">

**Author:** [@dtaylor01](https://forums.toadworld.com/u/dtaylor01)\
**Replies:** 0\
**Last updated:** [January 25, 2024, 10:52pm UTC](https://forums.toadworld.com/t/migrate-toad-z-os-components-tables-from-non-uts-to-uts-tablespaces/58856 "2024-01-25T22:52:04Z")

</div>

When setting up Data Sharing in our shop and going through the Toad for DB2 zOS Components Installation steps on the z/OS side, I had to add to change the application compatibility in a few places as the INSTDDL script w…

---

## [2-char delimiter?](https://forums.toadworld.com/t/2-char-delimiter/57779)

<div class="topic-metadata">

**Author:** [@Dozalito](https://forums.toadworld.com/u/Dozalito)\
**Replies:** 4\
**Last updated:** [July 26, 2023, 10:22pm UTC](https://forums.toadworld.com/t/2-char-delimiter/57779 "2023-07-26T22:22:03Z")

</div>

Can you use TOAD to export to a CSV file using a 2-character delimiter between values such as |^ ? I currently use AQT which they are taking away and TOAD is one of the potential options they list as a possible replacem…

---

## [Move the GTT from Additional Objects --\> Temporary Tables to a Dedicated Tab](https://forums.toadworld.com/t/move-the-gtt-from-additional-objects-temporary-tables-to-a-dedicated-tab/54877)

<div class="topic-metadata">

**Author:** [@AJD](https://forums.toadworld.com/u/AJD)\
**Replies:** 0\
**Last updated:** [March 15, 2022, 3:28pm UTC](https://forums.toadworld.com/t/move-the-gtt-from-additional-objects-temporary-tables-to-a-dedicated-tab/54877 "2022-03-15T15:28:51Z")

</div>

Move the GTT (Globally Temporary Tables) from Additional Objects --\> Temporary Tables to a Dedicated Tab on the Object Explorer window. ( Just like the Tables Tab, Views Tab, Indexes Tab)

---

## [Add feature that allows Admins to prevent users from adding new connections to DB2 client catalog](https://forums.toadworld.com/t/add-feature-that-allows-admins-to-prevent-users-from-adding-new-connections-to-db2-client-catalog/50695)

<div class="topic-metadata">

**Author:** [@VMD](https://forums.toadworld.com/u/VMD)\
**Replies:** 0\
**Last updated:** [August 18, 2020, 9:44pm UTC](https://forums.toadworld.com/t/add-feature-that-allows-admins-to-prevent-users-from-adding-new-connections-to-db2-client-catalog/50695 "2020-08-18T21:44:03Z")

</div>

Currently, when Toad is used on a shared terminal server, providing users access to the pre-configured connections within the DB2 catalog also allows them to add additional connections to the catalog using the connection…

---

## [The ability to change the font size for Connection Manager and Object Explorer](https://forums.toadworld.com/t/the-ability-to-change-the-font-size-for-connection-manager-and-object-explorer/42096)

<div class="topic-metadata">

**Author:** [@susan.kilpatrick](https://forums.toadworld.com/u/susan.kilpatrick)\
**Replies:** 4\
**Last updated:** [February 18, 2020, 7:29pm UTC](https://forums.toadworld.com/t/the-ability-to-change-the-font-size-for-connection-manager-and-object-explorer/42096 "2020-02-18T19:29:28Z")

</div>

Request from customer: It's possible to change the font size for the Editor, however, currently it's not possible to increase the size if the fonts in the Navigation Manager, Connnection and Object Explorer. Increasing …

---

## [Dataset Name Template 'TIME LOCAL'](https://forums.toadworld.com/t/dataset-name-template-time-local/47874)

<div class="topic-metadata">

**Author:** [@llmaberry](https://forums.toadworld.com/u/llmaberry)\
**Replies:** 0\
**Last updated:** [October 14, 2019, 3:29pm UTC](https://forums.toadworld.com/t/dataset-name-template-time-local/47874 "2019-10-14T15:29:08Z")

</div>

When we generate our batch jobs on z/os we have a Date and Time included as part of the dataset name and we use 'TIME LOCAL' in our template, could that be a future enhancement. Please VOTE Thank you, Lyn M.

---

## [Generate Dataset Name using PART(3,3)](https://forums.toadworld.com/t/generate-dataset-name-using-part-3-3/47872)

<div class="topic-metadata">

**Author:** [@llmaberry](https://forums.toadworld.com/u/llmaberry)\
**Replies:** 0\
**Last updated:** [October 14, 2019, 3:26pm UTC](https://forums.toadworld.com/t/generate-dataset-name-using-part-3-3/47872 "2019-10-14T15:26:39Z")

</div>

When Toad generates a DSN with PART, the dataset name is too long, so we use in our batch jobs this \>\> 'ZJDB.&DB..&TS..D&DATE..T&TIME..P&PART(3,3).' But when I try to use the PART(3,3) in Toad it throws an error, so I r…

---

## [Disable SQL Recall](https://forums.toadworld.com/t/disable-sql-recall/42179)

<div class="topic-metadata">

**Author:** [@esheridan](https://forums.toadworld.com/u/esheridan)\
**Replies:** 2\
**Last updated:** [October 10, 2019, 9:42pm UTC](https://forums.toadworld.com/t/disable-sql-recall/42179 "2019-10-10T21:42:20Z")

</div>

Due to security concerns, my company does not allow any queries that are ran against production databases to be stored on my workstation. I was recently flagged in an audit due to the Toad SQL Recall XML which displays t…

---

## [Consolidate individual alters that can be combined into one alter statement](https://forums.toadworld.com/t/consolidate-individual-alters-that-can-be-combined-into-one-alter-statement/42139)

<div class="topic-metadata">

**Author:** [@kevin\_krause](https://forums.toadworld.com/u/kevin_krause)\
**Replies:** 0\
**Last updated:** [September 28, 2017, 5:40pm UTC](https://forums.toadworld.com/t/consolidate-individual-alters-that-can-be-combined-into-one-alter-statement/42139 "2017-09-28T17:40:40Z")

</div>

If a configuration parm currently exists that will allow this please let me know (I looked but couldn't find anything). When altering columns of a table using either the alter table function from the browser or as a res…

---

## [Color Rows in Index Viewer](https://forums.toadworld.com/t/color-rows-in-index-viewer/42313)

<div class="topic-metadata">

**Author:** [@robert.krall](https://forums.toadworld.com/u/robert.krall)\
**Replies:** 2\
**Last updated:** [June 14, 2017, 6:36pm UTC](https://forums.toadworld.com/t/color-rows-in-index-viewer/42313 "2017-06-14T18:36:42Z")

</div>

I love how there is a tab for Indexes when viewing a table within in TOAD for db2. I have a suggestion which might make it easier to tell the differences between indexes. currently you color every other row white and t…
