I'm using AQT 7.1.2 going up against Oracle tables and have no problems. When we first started going up against Oracle we'd get the same error message. It...
Phil gave me a work around in which I changed an option for Table Information from "Use Parameters" to "Use Substitution". This worked for me. I guess the...
I'm not about clear what you are trying to do.... if you are trying to get the query data as a comma-separated set of values, then the methods I described will...
While setting "Use Substitution" is a workaround, it doesn't explain why the problem is happening, which is a mystery to me. It's occurring during AQT's use of...
Hi Phil, if i try to export data to sql-window i get the error 'Processing error at get_data_file ...........'. this happens if anything is defined in the...
What version of AQT are you using? It works OK for me - perhaps some of the other parameters you are using could be contributing factors. If you go File >...
Hi Phil, when selecting a table or view in the SQL-editor, the function Table / Display Query Table <F9> opens the Table and shows the contents. This is...
Hi Ron, I've implemented your option for the scripts. There is now a parameter append=y which will cause the SQL to be appended to the file. This enables you...
Ah yes, that brings up a distant memory. The definition of GTTs are not in the DB2 catalog so AQT cannot display the column info. What I'll do (sometime in a...
Phil, Excellent product.... I know you can compare tables, and data, but how about a full schema compare to include stored procedures, triggers, synonyms,...
Oh, that's wonderful. Have I understand this right: That would make it possible to load the column-window by pressing <F2>, isn't it? That's more than I have...
Hi Rich, Try the rightest icon above the middle grid with the tooltip "compare". I think this will do what you want. @Phil: A suggestion for the Menue: Perhaps...
No, sorry - I've seen this icon compares the definition of tables, but not stored procedures, triggers, synonyms as you want. To compare these objects, I would...
Yes, that would allow F2 to load the col list. F9 should always works as it doesn't need to col list (it just does a "select * from table"). Phil. ... ...
As Josef has mentioned, the "Compare Objects" function can compare objects other than tables. As with AQT v7.1.4 I have added this compare functionality for...
Phil, Yes, I saw that function, but when I do the compare, it allows Tables, Columns, PK, FK, Check Constraints, Triggers and Synonyms, not functions,...
If you click on a function or procedure, the Compare button will be active and you can click on this to compare these objects. It wasn't part of the...
Good enough Phil. Thank you, and thanks again for an excellent product.... ... be ... wasn't ... of a ... are ... Synonyms, ... the ... compare ... this ... ...
Hi Phil, I have a problem finding the compare-icon for SP, functions etc. When clicking on such an object, the icon does not appear. There are only the...
Hi Phil, I have a problem finding the compare-icon for SP, functions etc. When clicking on such an object, the icon does not appear. There are only the...
Hi Phil, The append for scripts/reports is very useful. (Unfortunately I was not able to read the help - it just said 'page cannot be displayed'). Would it...
The append flag should be on the Save Compare Options - you should see a new parameter append=y which you can use in your scripts. Odd that you can't display...
Hi Phil, I'm sorry that I wasn't clear enough. What I meant was that from the "Data Compare" window you can select the "File" action bar and you get a...
Hi Phil, I have sometimes the requirement to write some SQL to select data form the systemtables. Most of them approximates the SQLs AQT uses in the background...
An interesting idea. I'll add it to our list of possible enhancements for v8. I suppose you know that you can see the SQL by going Tools>Configure System...
I understand. I can see that it would be useful ..... I'll give it some thought (may then need to add the append option to a lot of other windows to be...
What database type and version of AQT are you using? Compare for SP, functions etc was only added in AQT v7.1.4 - it was configured for most but not all...
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.
