Hi Phil, I have more information ... this is complicated (and simpler too). My previous posting was not a complete solution: z/OS query: "SELECT CAST(v AS...
Phil, I am getting a random error when AQT runs several (7) data compare query statements in batch. If I run the statements a second time, all frequently run...
This is not a problem we are aware of. Could you email me the ODBC Trace file - there may be something in there which might help with this. Phil. ... all ... ...
Phil, Here is the ODBC trace file along with the file I ran, and the output files. The ODBC trace shows very little (to me anyway). I've tried to find a ...
AQT does not current have a scripting or batch option for generating DDL. Is there any plans for this in a future release? regards, -brian laube p.s. I have...
Hi Brian, Scripting of DDL is on our list of future enhancements, though there aren't any immediate plans for it. Phil. ... generating ... I am ... db2...
How do i close the specific excel spreadsheet?? as I am trying to run more than one AQT jobs at the same time. do we have something like --aqt closexl...
You can close a particular Excel workbook with: --aqt closexlfile,file=TheSpreadsheetThatIWantToClose.xls This feature was implemented in AQT v8.2.5. so you...
Any clues as to why only some excel files open?? We are using version 7.16 (please don't tell me to upgrade - I have no control over that :-) Thanx -Kono...
I figured it out - a little time in the help documentation gave me the answer I needed. In Excel, you need to create named ranges. Each named range will come...
Hi, I have an AQT 8.2.5 query which is connected to an Informix db using the IBM Informix ODBC ver 4.0 driver. After 900 seconds (15 minutes), the query quits...
This is nothing that AQT is doing. This is due either to a comms problem on the link, or your query being timed-out by Informix. I would suggest contacting...
Hi Phil, hope things are going well. Here are 3 things I would like to see sometime in the future: 1) handling the loading of multiline text fields 2)...
I am trying out this software, and we could really use it in our organization if the application could connect to our IBM DB2 mainframe system. The help files...
Thanks for the suggestions. The loading of multi-line fields is a problem as AQT (like most loaders) assumes that each line in the input file loads into a row...
Yes, AQT can indeed connect to DB2 z/OS. To do so, you will need to use DB2/Connect to provide the connectivity to the mainframe. This is discussed in the AQT...
I can attest that AQT works just fine with z/OS. I have ESE/winXP on my machine, which has a version of DB2/Connect, so the setup is transparent. Using the...
Yes, it is very trivial to connect AQT to your z/OS database. I've done that numerous times, usually from my PC running DB2 8.x or 9.x. DB2 Express-C provides...
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...
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.
