I have to bounce data from an SQL Server database against an Oracle Database. Is there a connection string format or other means available to connect the two...
Hi Am trying to execute a query like select t1.*, row_number() over (partition by t1.col1, t1.col2, t1.col3 order by id.last_update_dt desc) rn from tab1 t1 Am...
You cannot run a query in AQT that gets data from more than one database. Some database have features whereby tables in another database appear to be within...
Missed information is AQT was pointing to a different DB server than my local one. Looks like OLAP enablement will have to be done at the db2 server side. Help...
AQT just sends the query to the database and displays the results. There is no reason why you cannot run an OLAP query in AQT. What message do you get when you...
After few attempts I do not think that this is an issue with AQT. Rather in the zDB2 server side I guess. Am getting the below error ... select id.cont_id,...
You got it right. Mine was v8.2. No OLAP available. This is very generic Q and nothing to do with AQT, is there a better way to implement row_number() over()...
i'm using v7.1.7 of aqt, and after having my hard drive copied to new computer, i'm suddenly having problems generating insert statement scripts which use...
The Insert script generated by AQT will always represent a Null value as NULL. This is a keyword used by all databases to represent a null value, which is why...
When we program in our mainframe we like using the quick keys and/or macros. In the Run SQL I was wondering about user defined shortcut keys? Two quick...
I am using AQT 8.2.7. It is a great product.. I have been using it for years.... I have a situation that AQT -the favorites folder- would work terrific...
You can certainly run the Insert statement. After selecting the query, click on the SQL icon in the toolbar. This will open the Run SQL window with your Insert...
No, we don't have shortcut keys as such. However you could add 2299-12-31 as one of the Keywords. In the Run SQL window, go File > Edit Keywords. Add the...
We are having a problem with table and view ownership as shown in AQT. We use multiple schemas in SQL Server 2005 and they do not come across properly into...
Could you let me know what version of AQT you are running? Support for SQL Server 2005 was added in AQT v8. Also, if you to Help > Database Details, for Config...
I am currently moving to a new machine but AQT will not install with what I thought was my key. I'm using AQT 7.0. Is there any way you can resend this info...
Issue has been resolved. Used the Help - Troubleshooting - Unable to display table information. It's an issue with AQT and SQL Servers system tables....
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...
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.
