Toad World® Forums

Toad for DB2 Beta


#1

The Toad for DB2 Beta Program is under way.

As of January 30, 2019 - drop 7.0.1.12 - is available.
This drop contains fixes and enhancements.

Quest’s beta programs are your opportunity to participate in the development, direction, and quality assurance testing of our products. By becoming a beta tester you have direct access to the development team and product management.

Instructions

  • Read the Beta Test Agreement. Downloading the Beta constitutes usage agreement.
  • Download the installer zip below and run the installation exe file.
    Do not install the Toad Beta into your commercial Toad folder, if it exists.
  • Review Beta Release Notes
  • Post your feedback by posting a Reply to this forum topic. Remember your feedback counts!

Important
We have modified our version number from 6.6 to 7.0
If you have a beta version 6.6 installed - you must uninstall it prior to installing the 7.0 beta

Download

Download Beta
Build 7.0.1.12 (32-bit and 64-bit) - updated January 30, 2019


New Toad DB2 v7.0 Beta Drop - 7.0.1.12 has posted
New Toad DB2 v6.6 Beta Drop - 6.6.0.578 - has posted
Real Time Statistics Advisor Overflow Exception
Automation compare deactivate summary report
pinned #2

#3

Hi Jeff,
I downloaded the Beta about two weeks ago. It is a pretty nice advance as far as useablity is concerned.
I use automation files extensively, to record and save data before updating any record. As the TAS files are not backward compatible, any change that I make needs to be done on the previous version.

Is there any solution to that?

Shimon J.


#4

Shimon,
I forwarded your question to our automation expert and this is her reply:

We will never support backward compatibility. Only forward compatibility.

If a user needs to retrieve his old tas file he can go to app data dir\Automation\bak and there will be a copy of the old file before converting.

C:\Users<user>\AppData\Roaming\Quest Software\Toad for DB2 6.x\Automation\bak


#5

Thanks,
I’ll give it a try, as usual.

Shimon J.

P.S. I used to get a mail when a new version was posted. I didn’t this time. Maybe it’s because you just updated the post and didn’t post another thread.


#6

I don’t mean to be nit-picky, but the release notes for this version should be updated.
It says that the system requirements are:
.NET 4.5.1 .
The actual requirements are 4.7.1.


#7

Thanks we will make a note of that and change it in our future release.


New Toad DB2 v6.6 Beta Drop - 6.6.0.422 - has posted
New Toad DB2 v6.6 beta Drop 6.6.0.377 has posted
The Toad for DB2 v6.6 Beta Program has begun
pinned #8

#9

Thanks.
Will give it a try.
Shimon J.


#10

I have a suggestion to improve the compare feature of Toad. I use it mainly for Reference Tables across different schemas.
It would be great if there would be an option to have the result of a compare ( or as a stand alone option) create Merge into statements for every row in the table.
We had some of our experts write up such a script. I am willing to share them with you, if that would be any help.

The idea is that even if I need to update some reference table across many schemas, I would’nt have to do a compare on each, just run the update / insert scripts for X rows.
Sincerely,
Shimon M.


New Toad DB2 Beta Drop has posted
#11

The new feature “Toad now allows users to specify their own custom connection string …” does not work for me.
Whenever I try to type in the properties for sslConnection and sslTrustStoreLocation, I get the error: “Connection string is not valid.”

What can I do?

Thanks in advance!
Wolfgang


#12

Please email me your connection string so we can take a look at it:
jeff.podlasek@quest.com

thanks
Jeff


#13

I thought that Jeff asked for a DDL of my table so I’ll paste it here. I’ll also paste a merge into statement that I would like to have created as part of a compare table.

SET CURRENT SCHEMA = P7TADMM;

SET CURRENT SQLID = ‘S87’;

CREATE TABLE P7TADMM.TTPR_PARAMETER (
ID INTEGER NOT NULL WITH DEFAULT,
AUDIT_ID BIGINT NOT NULL WITH DEFAULT,
VERSION INTEGER NOT NULL WITH DEFAULT,
IS_ACTIVE SMALLINT NOT NULL WITH DEFAULT,
ID_NAME VARCHAR(50) FOR SBCS DATA WITH DEFAULT NULL,
FROM_DATE DATE NOT NULL WITH DEFAULT,
TO_DATE DATE WITH DEFAULT NULL,
PARAMETER_NAME VARCHAR(100) FOR SBCS DATA NOT NULL WITH DEFAULT,
PARAMETER_VALUES CLOB(1M) INLINE LENGTH 3500 FOR SBCS DATA NOT NULL WITH DEFAULT
)
PARTITION BY SIZE EVERY 64G
IN D7TT.TSTTPR
AUDIT NONE
DATA CAPTURE CHANGES
NOT VOLATILE
APPEND YES;

COMMENT ON TABLE P7TADM.TTPR_PARAMETER IS ‘REFERENCE_TABLE’;

SET CURRENT SCHEMA = “P7TADMM”;


#14

MERGE into P7TADMM.TTPR_PARAMETER as TRG USING (values (-120,1,1,1,‘USE_DB2’,‘2018-12-27’,NULL,‘USE_DB2’,‘true’)) as DAT (ID, AUDIT_ID, VERSION, IS_ACTIVE, ID_NAME, FROM_DATE, TO_DATE, PARAMETER_NAME,PARAMETER_VALUES) on TRG.ID = DAT.ID when MATCHED then update set TRG.AUDIT_ID = DAT.AUDIT_ID , TRG.VERSION = DAT.VERSION , TRG.IS_ACTIVE = DAT.IS_ACTIVE , TRG.ID_NAME = DAT.ID_NAME , TRG.FROM_DATE = DAT.FROM_DATE , TRG.TO_DATE = DAT.TO_DATE , TRG.PARAMETER_NAME = DAT.PARAMETER_NAME , TRG.PARAMETER_VALUES = DAT.PARAMETER_VALUES when NOT MATCHED then insert ( ID,AUDIT_ID,VERSION,IS_ACTIVE, ID_NAME, FROM_DATE,TO_DATE,PARAMETER_NAME,PARAMETER_VALUES) values (
DAT.ID, DAT.AUDIT_ID,DAT.VERSION,DAT.IS_ACTIVE,DAT.ID_NAME,DAT.FROM_DATE,DAT.TO_DATE,DAT.PARAMETER_NAME,DAT.PARAMETER_VALUES);