When running a AQT batch file (running a AQT sql script), if I leave the DOS window in focus, the batch file finishes and sends up its message. But if I bring...
I inadvertently removed the Blank Line at the bottom of the sample batch file. Not having the Blank Line hoses the command processor on DOS. Great OS. ... ...
Hi Phil - I've begun to use the data compare option -- primarily in batch -- to validate a data migration. In my test, I am comparing the same DB2 LUW table...
Not to discount AQT, but with this volume, and the same version of DB2 on ASCII(unicode) platform, federating the two tables, and doing a UNION SELECT will pop...
Yes, that would work nicely. My real world situation is a non-IBM database compared with a DB2 LUW database. (I'm trying the AQT compare on two LUW databases...
Hi, Here is a fix for you. Download: http://www.querytool.com/aqt824c.zip unzip to: C:\Program Files\Advanced Query Tool\ Regards. -- Troy Pascoe Technical...
Hi, 1. AQT does the compare by running a query such as: select * from table order by pk_cols DB2 will often decide to process a query such as this by reading...
Hi Troy -- Thanks for the information! I'd sort of guessed it was the DB engine's ability to support the query that really drives the speed of the compare. I...
Hi, The Filter option on the Database Explorer window is used to filter the table object list. You can see a sample of the rows by choosing "Table Contents...
Anyone got a sample batch sql statement to get data from both informix and MS Access?? do we have something like this in sytax?? --aqt connect,dbs=informixPROD...
Hi, AQT cannot do cross-database queries. When you run some SQL it goes against one database; if the SQL refers to any tables not known to that database, the...
I have just been asked to compare transferred data from SQLServer to DB2. But the Options doesn't allow for the fact that numeric columns in SQLServer got...
v8.2.4 viewing DB2/LUW/8.2.5 The column is Integer, with NULL values. Columns that are Character (with no NULLs) sort fine. The presence of NULLs may be the...
This is a limitation of the grid. When a column is defined as numeric, it has trouble coping with grid values which have a value of (null). This is because...
Put this at the end of your SQL script: --aqt closexl It's a feature Phil added for us a long time ago when we first started using AQT for batch reports to...
Hi, You can add a Where clause in the Filter Rows text box, eg. where cust_code = '000111'. This will limit the number of rows compared in the table. Regards. ...
Hi, I am new user of this product, dont knw much in detail but exploring it. Please let me know the procedure to the same. I am waiting for responses....
Hi, Is There any Backup Command in AQT???? Please advice, how to take backup using AQT for Sybase and also how to use encrypted password during login using api...
No, there's no ability to do this. However: a) AQT just compares the values irrespective of column type. So a character value '123' will compare the same to a...
Hi, If you are using Sybase ASE then use the: dump database command. eg. dump database yourDB to 'c:\foldername\dump1.dmp' What do you mean by "api"? Regards. ...
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.
