Hi, I am evaluating a copy of your product and have found a problem with Unicode script generation. The special character in Gödöll won't be inserted...
If you go to Options > Unicode Options, select the option "For SQL Server, ensure Unicode strings are in N'xxx' format", this should do what you are wanting. I...
Is it not possible to have a literal that includes both date and time for Oracle? I tried exporting table data as insert statements and I get this error: ...
The following was originally a Delete, and worked fine; edited various ways, comments and sql. In 8.1.2, it returns most, but not all of the table. 8.1.2 EE,...
My DBs have a timeout set on one of our test DBs at 5 minutes. This makes testing a nuisance sometimes as I have to keep closing the connection and reopening,...
What seems to be happening here is that the SQL is being passed to DB2 with the comments included. You should check Options > Run SQL > "Remove Comments from...
... Phil: That fixes it. Don't remember DB2 misbehaving before, nor that the option was even there in AQT. Phew. thanks, Robert ... DB2 ... selected...
To my knowledge, the only way of specifying a date literal with a time portion is to use the TO_DATE function, eg. TO_DATE('2006-01-21 12:34:56','yyyy-mm-dd...
This problem is unique to one user in our shop. Can access the data from his desktop using the command line processor. Only the table with the clob is a...
Hi Phil, I'm trying to do some queries to several TXT file but couldn't get it to work. Here is what I did: 1. Setup an ODBC DSN called TXTData and point it to...
AQT doesn't have this per se, though in the future we will have an option to auto-refresh a query (which will do what you are wanting). You *can* do this if...
I've had a look at this. It seems to work if table-ids are used. In the Query Builder, go to the Options tab, click on Table Id and select an option such as...
I presume that the text for this error is something like "THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE IT WAS IN ERROR AT BIND TIME FOR SECTION etc". This is...
Hi Phil, When I generate the DDL for triggers on informix it adds an extra semi-colon at the end. Generates it fine on DB2 though. Can forward screen-shot if...
Hello, I'm a data warehouse consultant, working with version 8.1.2 of AQT. Since I'm working at multiple sites, I have a multitude of database connections to...
Thanks, I'll add these suggestions to our list of enhancements. Adding resizing to this window shouldn't be too difficult. You can currently increase the MRU -...
Phil, Thank you, I had missed the existing option to specifiy the number of entries to keep. I have a few more enhancements I would like you to consider: 1....
I am trying to use the dataloader to move data from a table in an SQLAnywhere 7 database into an Oracle 9.2 database and am getting the following errors: ...
This is true. Is this a problem for you? The Trigger text (as Informix holds in the system tables) has a semi-colon at the end of the text. AQT also places a...
1. OK. This can be done. If you use a number of different databases frequently another option would be to have a different ODBC Datasource for each of...
1. Different ODBC's would be an option, but certain sites have an average of 3 to 4 logins per server, each login having access to a different set of...
Phil, Thanks for the response, this doesn't work for me though as the columns in the Oracle database are defined as not allow nulls so when it tries to...
Hi Phil, It's working now. Thank you so much! Kee ... In ... select ... get ... Select "txtdata1.txt".field1, "txtdata1.txt".field2, "txtdata2.txt"....
You are right, it doesn't seem to be easy to do. I'll add a new function to allow this conversion to be done. Shouldn't take me more than a few hours - I'll...
You can download a build of AQT from http://www.querytool.com/aqt813d. zip - unzip the file into your AQT directory. I would recommend backing up your existing...
Pascal, I have fixed this - the fix can be downloaded from http://www.querytool.com/aqt813e.zip - unzip the files into your AQT directory. informix_adm.cfg...
1. OK, I can add the database to the recent list. I may redesign the signon window (there are some other changes people have requested) - as this is a biggish...
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.
