Hi All, I want to build query using two different database. I have opened A and B database, I clicked on the "Build Query" but I couldn't use tables of both A...
BTW, since V8 i've tossed all my other DB clients. Anyway, simple question that I could not find in forum search. Can I substitute EDITPLUS as my editor of...
No.... this isn't possible. When linking to an external editor, AQT needs to pass the SQL to the editor then wait until the editor closes the file. This...
Hi Phil, i try to create an batchexport using headercolum. but i want to delimt the columnname with ' " '!? Is it possible to do so? what i have to define? ...
So... you want the column names to have double-quotes around them? I don't think there is any way of doing this easily. In the Export Options window, you can...
Hi Phil, thanks - it works! 'it seems to work better if you have a blank after the colheader=" and before the column list.' => this is the solution. i have...
Export function of the AQT version 8.2.2 Extended Edition To load table I'm using the Data loader Tool - Load Data from Query. On the query text I placed my...
I suggest upgrading to the latest release, AQT v8.2.7. There was a problem in this area that was fixed in AQT v8.2.3. Upgrading to the latest version should...
This type of thing only really happens if you have the query open in two different places in AQT. For instance, you may have the query open in both the Run SQL...
This happens to me too. I modified my query, but I don't want to save changes. Yet, AQT forces me to save if I try to go back to the query window after the...
Hello, I need to pass value at runtime to a sql query. ex: select * from emp where empid = ? when you are trying to execute the query, it is asking the value...
Yes, you can use user-defined parameters. Eg: --aqt queryparm,parm=emp,desc=Enter employee id select * from emp where empid = '$emp' If empid is a numeric...
I will be out of the office starting 07/16/2009 and will not return until 07/27/2009. I am out of the office on vacation. I will be in the mountains, so I...
Phil Nice feature --aqt queryparm,parm=emp,desc=Enter employee id,select=(select distinct empid from emp) select * from emp where empid = '$emp' Works fine I...
I'm moving departments, within an organisation. I've got AQT 7 installed. The new department is purchasing AQT 8. The old AQT 7 license will remain with the...
No, if the V7 license is going to be used by someone else, you will need your own AQT v8 license. You will need a full license, not an upgrade license. Phil....
Hi, I have noticed on the latest version the Histroy SQL window does not "remember" the size setting anymore. Whenever, I start AQT, the History window is a...
Hi, I am not sure why the window size is not being saved. The best thing to do is to delete the settings in the registry. To fix the problem open: "Registry...
Hi Raj, In order to understand what is happening could you provide some screenshots? A screenshot of the history window would be helpful, and also, one of the...
I'm using aqt 8.1.6 with IBM UDB 9.1, since my IBM upgrade to 9.1 I cannot display lobs or use the options to send the lobs to files. Has anyone else...
This problem has not been reported by anyone else. When you say you upgraded to DB2 v9.1, is this your DB2 Server or DB2 Client (or both)? You can often run...
Phil, thanks for the reply, soon as I get a chance I will produce the debug file you mention, I just verified with our dba, the server is at 9.1, my client is...
Phil, I put the file in this groups "files" as "aqtdebug_PROBLEM_DISPLAYING_LOBS", pls excuse my ineptness with this forum/email/posting stuff, not used to...
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.
