I changed the following queries in db2390.cfg to at least return a result to the Right Grid. The ODBC functions that were being called did not exist for a V8...
Can you put some window snapshots of the new "Table Loader" feature out on the Future Releases webpage? I noticed you did it for the new Adminstration...
A good point. You probably have an "oldish" version of Sybase that does not recognise Ansi join syntax. I have tried not to use these in the system queries,...
Partly this is because the Data Loader isn't all that "sexy" - just has a bunch of boring- looking dialog panels. I may see if I can put something together....
Phil, We recently started using identity columns in DB2 z/OS V7. We create these identity columns as "GENERATED BY DEFAULT" which allows the value to be...
That is an excellent analysis of the problem. If you find your db2390.cfg file, you will find a line looking like: 20;c;Column list for;SELECT NAME, COLTYPE,...
Dear all, How can I add a user to a database? I tried to grant a user execution rights on a table but it would not work because the user was not known in the...
Hi Dorine Adding a user to a database is part of the database functionality, it isn't done through Advanced Query Tool. Your database Help or manual will be...
Hi Phil, I run several sql-statements from the sql-window, sometimes one after another by marking a single command and execute it and then get a window for...
Dirk Reckeweg
dirk.reckeweg@...
Jan 14, 2004 9:34 am
607
Thanks Phil. I will ask the system administrator to add the user. Thanks again!...
There are a number of points here: 1. the best way of going from the results window back to the SQL window is to click on the Run SQL button in the AQT...
i have this recollection of running a script to export multiple tables from DB2/390, but i don't find "Run as DB2 Command" anymore?? could i just be losing it...
This feature is only available for DB2/UDB as most of the commands you would run through the Db2 Command Window (Runstats, Reorgs etc) only run against DB2/UDB...
Additionally, I believe that if you have the DB2 Administration Server (DAS) for z/OS, which runs under Unix System Services (USS), then all of the utility...
Hello, Does anyone know if there is a version of AQT that supports viewing UTF8? I have a database I am connected to that works with XML documents and supports...
Hi, I think two features would make AQT even better: - enabling in some way a quick selection of tables (i.e. F2 or right click to make a list of table to...
I am not an expert on multiple character sets, but hopefully the following will answer your question. AQT, being written in Visual Basic, uses Unicode...
You can select another table by hitting ctrl-T. Auto-completion is good idea, and I'd love to be able to offer it. However it isn't possible with the...
I am using AQT with DB2 UDB v8.1, Oracle 9i. It is immensely helpful. 1) I've used scripting to automatically logon / establish multiple connections. It...
In answer to these: a) in AQT V6, AQT remembers the last 10 signons you have done, and will remember the passwords used with these. b) a good idea, I'll put...
i am using aqt in batch-mode to 'export' a table. if i am using the gui to export the data there is an option 'include blank between columns?'. in Batch-mode i...
Hi, I think that a useful feature would be a row count for each group (at all levels), when using the group-by feature of AQT. The group rowcount could appear...
Hi Phil, I want to make sure I understand the move to upgrade of AQT. I am a registered user and I am currently using AQT Ver. 5.60. On the web site it looks...
The way you describe it is correct. The DBA functions will cost you more - you will have to purchase an upgrade from Standard Edition of AQT to Extended...
... Phil: since i spend a good deal of time talking to mainframe DB2, will the DBA functionality work in that environment? the native DB2 client uses DRDA,...
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.
