Can you let me know what version of AQT you are running? I have been trying to reproduce this error you are getting (without success) - perhaps you are not...
Phil, I am running version 8.1.5, yep it is an older version. Is there something you would like me to try, or did you want to see the SQl. Terry 920-433-5112 ...
Thanks. I can't reproduce the problem in AQT 8.1.5 either. Could you go to Options > General, switch on Debug Mode, reproduce the problem, then email me the...
Phil -attached, this going after SQL 2005 DB
Terry
From: aqt@yahoogroups.com [mailto:aqt@yahoogroups.com] On Behalf Of Phil Castle
Sent: Wednesday, October...
Hi, we are using system monitor for our company (oracle 10g). Just wanted to confirm what tables a user needs access to in order for the system monitor to...
They need access to: Views SYS.V_$BUFFER_POOL_STATISTICS SYS.V_$ROLLNAME SYS.V_$SESSION SYS.V_$SQL SYS.V_$SQL SYS.V_$TRANSACTION Plus synonyms DBA_LOCK ...
Thanks. What I think is happening is that you have an invalid timestamp value, eg. day, month or year is outside the valid range. When AQT reads the timestamp...
howdy... question for you I have AQT 8.2.3 hooked to an oracle 10g database. Is their a way to either save off my histroy buffer or define which tables to...
There's no way of saving the history buffer between sessions. What may be useful for you is Options > Table Information > "Show Favorites on Startup". When...
I am still considering purchasing AQT, but have not been able to locate an answer about scripting. Does this tool enable scripting that integrates with DOS and...
Yes, AQT scripting can be run from a .bat file. In your AQT directory, see files batch*.* which gives an example of the use of AQT in batch. Phil. ... locate ...
Trying to load data into a table... Logged on to one database (Oracle 9).... ran query to generate rows I require...fine.. Then log on to another db (exact...
There are two issues here: Displaying as DOUBLE PRECISION. The Data Loader will run your query and display (on the Mapping tab) the data types of the columns...
Phil Thanks for your prompt response. Here's my findings: 1. Yes I confirm that the TO_CHAR version of the query gives me more decimal places. In other words,...
I will look into this further then get back to you. Phil. ... more decimal places. In other words, my original query had already lost some digits even before I...
Phil, Just some more info for you.... performed a test.... 1. Regenerated my lookup table schema using VARCHAR2 (60) columns instead of the original...
I've just looked at this further. The FLOAT value are OK in the database, they just don't display in AQT. Within AQT, the FLOAT values are mapped to a Windows...
Phil, Thanks for this........ but here's some more info that may have compounded the issue ..... Here's the story... I needed to create a lookup table. In...
Hi Phil - I've been stymied for a while wondering why data compare runs so slowly when I target two large tables (e.g., 10M rows) and ask AQT to stop after the...
The query AQT runs is SELECT * FROM TEST.CUSTOMER_TAB ORDER BY CUST_CD,CLAIM_NUM Based on the "Max rows" you have specified, AQT will set the ODBC attribute...
Phil, I've tried the OptimizeForNRows (I'd already come across that). Unfortunately, that does not instruct DB2 to avoid the table scan / sort of the result...
Ah yes, I guess you wouldn't be the first person to discover that the DB2 Optimizer doesn't always choose the best access path. It certainly has a fondness for...
I've running 8.2.5 Extended but I've seen this problem for a while. When I was just running AQT once in a while I could live with it but I'm on a project where...
Whats probably happening is that AQT is opening a dialog window to show you the data, howewever you cannot see this dialog window. This could be because it is...
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.
