Hi, Can I execute DDL and Trigger in SQL window at on execution ? I understood I must change delimiter setting to execute script in SQL window. I want to...
Hi, Yes AQT will work fine on win2003. One issue that users have run into however is Windows Data Execution Protection. Windows has a feature called Data...
You can run a script as a single statement by specifying Options > Run SQL > Statement Delimiter > None. Alternatively, when you generate DDL for the trigger,...
Hi, I am running version 8.2.4 and want to upgrade to the latest version. When I install ver 8.2.6 overtop of the older version, will all of the Option...
I try running the follwoing command: --aqt connect,dbs=PROD,user=xxtpr,epwd=xxxxx however, I get the foolwoing error: ***ERROR: S1090(0)[Oracle][ODBC]Invalid...
You are right, the Yahoo group search doesn't seem to work well. This is something we have raised with Yahoo (no response yet). In the meantime you can use...
This can happen if the epwd is not a valid encrypted password. What has happened is that AQT has gotten an error decrypting the password, which results in this...
We're trying to use AQT's scripting-feature to automize running of sql-scripts. We would expect the processing to stop whenever a SQL-error occurs. However...
This is true. When AQT gets an error, it sets the return code to a non-zero value. This is so the calling batch script can detect the problem and take...
I am using the AQT Loader to move some data from a db2 (9.5) database to an Oracle 10g (10.0.2.1) database. The DB2 table contains a TIMESTAMP column that...
Hi there, Oracle DATE values only contain the Date, plus the Time to the nearest second. It doesn't hold any decimal part of the Time. If you want to hold...
I have a load I am doing from DB2 to Oracle and some of the columns are defined as NOT NULL. In the DB2 database the columns contain empty string which is not...
Hi, I've created two parameters by going ot tools> parameters. I'm using the default parameter indicator of $ and Enable Parameters is checked. I've used the...
Hi, From the main menu try: Tools > View SQL after parameter placement This will show you the SQL that is being run with the parameter replaced with the...
And can be downloaded from http://www.querytool.com/download.html For info on what's new in this release, see http://www.querytool.com/whatsnew.html Phil....
Hello, Thank you for your reply. After I posted this, I found out the problem. Coudn't retract the question, since it was still not available on public view....
Why is it that I can not do multiple left joins in AQT when reading in excel files. I never have had a problem doing this with DB2 or Oracle but this is...
Actually I should clarify... I was proofing my query and obviously wasnt' accurate since I actually want the 'A' table to be the one every thing is left joined...
Yes, this will an Excel thing. Every database has it's own slight variations on the SQL syntax, especially for complicated things like multiple joins. You...
Bizarre... always has to be some crazy m$oft thing. That did not work. I have searched high and low, but havn't found anything. I will post back here if I...
This worked in my test... SELECT A.*, B.*, C.* FROM ([sp_employees$] A LEFT OUTER JOIN [Persona$] B ON A.GPID=B.GPID) LEFT OUTER JOIN [action$] C ON...
I've tried this on two different workstations-- both running AQT v8.2.7 on XP SP3. The find_replace (in SQL query editor) works fine, but when I hit [ESC] or...
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.
