Simple compare - all tables in schema produces erroneous results: some tables in the "right" schema is reported as not existing in the "left" schema and vice...
This problem is due to a difference of collating order between the database and your PC. AQT gets the list-of-tables by running a query such as: "select...
I've entered a paramater into a batch file and calculated a specific date, which works fine. I then pass that parameter to another parameter and do a...
In this, FiscalStartNov will get value: 11/01/2008 Then, CurrYear will get value: Year('11/01/2008') + 1 AQT doesn't do any calculations on parms, so CurrYear...
Hi, I don't think the Neon ODBC Driver is free. However, the vast majority of people use the standard IBM ODBC Driver, which comes as a standard part of the...
Hi, I don't think the Neon ODBC Driver is free. However, the vast majority of people use the standard IBM ODBC Driver, which comes as a standard part of the...
I am curious as to the status of development for aqt 9, the .net version. Any idea when it will be available, more specific than spring 2009? thanks, Brian...
Conversion to .Net is a massive job and we are about 2/3rds of the way through. We are estimating mid next year, however we can't be more definite than that....
Hmm. For those of us more inclined to Linux, will the .net version work, in some sense, on a Mono capable Linux (for those also willing to abide Mono)? ...
Hi Phil, We have talked about this before: the datacomp report file shows just the first 20 bytes of a datacomp query. You said it would be possible to...
Hi Phil, We have talked about this before: the datacomp report file shows just the first 20 bytes of a datacomp query. You said it would be possible to...
If you download the latest interim build of AQT v8.2.6 from: http://www.querytool.com/aqt826s.zip you should see the full text of the datacomp query. Phil. ......
Hi - Just bought 10 extended edition licences for a team of healthcare data/financial analysts. We're using it to replace a few applications....one homegrown...
Hi there, We do not provide any training in the use of AQT and we are not aware of anyone else who does. AQT comes with a comprehensive Help system that...
Phil, Thanks for the interim build. That helped greatly. I'm now getting a problem ("Error during SQLPrepare") running a datacomp query command while...
Hi, I'm running 8.2.2 and I find that the window "Customise Config File" has become read-only (although it states to double-click or hit F2 to edit, but that...
Hi I have been using AQT for a long time and I used to be very happy with it. One day AQT broke down and now I am not able to log in. I get a dialog with the...
Yes, the config file had some more things added to it. This made it a bit too complicated to amend the config file through the "Customize Config File" window....
Hi, I'm using AQT to connect to DB2 database. When I browse a table in AQT and check for column details for a particular table, I find that the data type and...
One more information...the field I'm referring to actually holds value which is of length 9 (eg 123456789). Thanks, Abhishek From: aqt@yahoogroups.com...
The length field comes from catalog table SYSCAT.COLUMNS and refers to the amount of storage used to hold the value. For Integer columns, this is 4 bytes (so...
Depending on what type of database you are running, AQT has a System Monitor. This will show you the users who are connected to the database. The System...
Hi All, This is the my first post. I do not know how to run the sp in sql window. I have done like this <sp_name>(id int, cur_our SYS_Cursor out) .... { call...
The following should work: { call <sp_name> (100) } or { call <sp_name> (?) } Phil. ... type. please send some sample. Thanks in advance happy New Year 2009 ...
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.
