Hello, A question on behalf of my sysadm... Our technical people are going to implement 2-way data sharing in our shop quite soon. My install sysadm asked me...
Hi Phil, I just upgraded to the v8 Beta 3 version from 7.1.6. This knocked out the "Simple DDL generator" for DB2 for AS/400, or at least it's now disabled on...
Hi Phil, I might be misunderstanding what it happening here. It seems sometimes the Simple DDL is enabled and other times it isn't. I haven't had the time to...
In theory, DDL generation doesn't work for physicals (and logicals), since these aren't created with a Create Table or Create View commands. In earlier...
Hi, like you, I can't imagine that there would be any issues between AQT and your DB2 environment. The interaction between AQT and DB2 is handled by the DB2...
Hmmm, let me think about it, OK, yes! :-) Seriously though, is the down side to this generation just that the definitions might differ from the originals...
It's not too difficult for me to enable the simple DDL generator for physicals and logicals. I will do this in the next build of the AQT v8 Beta. Also, on...
Thanks Phil! ... for ... AQT v8 ... exclude ... the ... the ... differ ... For ... it ... a ... for ... who ... getting ... Generation ... more ... seems ... ...
and can be downloaded from http://www.querytool.com/aqt717.zip For details of what is in this release, see http://www.querytool. com/whatsnew.html Phil....
Phil- I'm new to the software and have quickly encountered the problem defined below. The Safe Update Mode is the problem and it works if I turn it off....
As mentioned in that post, I deliberately do not save that setting. However I can add a button/option so you can specify that the setting is to be saved. I'll...
You need to go Options > Run SQL, set "Statement Delimiter" to None. This will stop the semicolon from being interpretted as a statement delimiter. In...
I am now using AQT for Oracle (replacing TOAD :-) as well as DB2 and I'm coming upon a problem. I have a table with the following definition: Create table...
This error normally happens if you are using the Microsoft ODBC Driver for Oracle (which doesn't support LOBs). If, instead, you use the Oracle ODBC Driver,...
Phil, When I print multiple copies of the query data to a printer whith the option "print on both sides" the the output is is not separated on different...
Posted this question 6 months ago. "Hi! I have a group of people in my company who are interested in using AQT against our production environment DB2 for z/OS...
When I attach to DB2 on an AS/400, the left pane shows all the libraries on thh AS/400. When a Library is selected, it shows the files within that library in...
I am using AQT to generate DDL for all objects in a database. I would like to generate CREATE TABLE statements with the OBID specified! For example: CREATE...
This can be done with a change to the cfg file for Db2 z/OS. I'll make this change and email it to you. I may not make this part of the default cfg file...
Hi Phil, I got to try out the simple DDL generator with that change you made for DB/2. (Allowing simple DDL generation for physicals and logicals). One thing I...
In theory, what you say is true. However AQT can't access the "view" definition of logicals. All it can do is to see the columns in the logical. So AQT can't...
Hi Phil, Suggestion -> The background for my last question was that I had a library with approximately 4500 physical or logicals in it. In order to get all the...
When you select a table in the Database Explorer, then go to the SQL window, AQT should place the schema-name / library-name in front of the table name. Eg....
What you can do here is as follows: from the Datbase Explorer, go to the drop-down list at the top of the middle grid. Select "Physicals Only". Then select the...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
