Is there any way when using the sql window, to force a reconnect every time a query is ran? My connection gets dropped a lot for a particular database ...
Hi John, no there is no option for this. On the Database Explorer window you can reconnect with File > Reconnect to. You could also try running the following...
Hi Phil, 1) After generating DDL for Sybase IQ Tables the FP Indexes should not be listed in the DDL. In IQ every field is always a FP Index (this cannot be...
This is an area I don't know much about. Sybase IQ shares the same admin config file as Sybase Anywhere: . are the LF, HG parms etc valid for Sybase Anywhere? ...
The LF, HG etc parms are only valid for Sybase IQ. The column index_type in SYS.SYSINDEX may contain these index types: HG, HNG, CMO, WD, LF, DATE, TIME,...
I'll add this as a problem-record in our system. I'll get back to you when I have something for you to test. Phil. ... types: HG, HNG, CMO, WD, LF, DATE,...
And can be download from http://www.querytool.com/download.html To see what's new in this release, see http://www.querytool.com/ whatsnew.html Phil....
I really like AQT. Did anybody know a Solution for this? I'm working with db2 UDB on a Win XP German Version. And another little problem is, that the last...
Hi, It may be it is trying to run comments and therefore can not find the SQL. Try downloading the latest version of AQT v8.1.6. Regards. -- Troy Pascoe ...
Another query tool, Golden Retriever from Bentic (only for Oracle), puts the cursor on the spot where it hurts. So, at least for Oracle, there seems to be some...
I thought Golden Retriever was a dog? I imagine that this tool uses native access to Oracle, which does get the row/col of the error. However this information...
Hi, It should give a message saying "No SQL Statement". Could you send me a screen-shot of the "Run Multiple SQL Statements" Window where you get your error...
Hi, We are heavy users of AQT here.... Have you ever considered adding a menu item "Edit/Save as New Table" to the query result window? Ideally a wizard would...
You can do this from the Run SQL window (rather than the Data Display window). Go Export > Export to Table. This will send the results of the query to a table...
Hi Phil & Others I suspect some of the logins I am using don't have rights to the system tables that AQT queries for it's data When I try to view DB links and...
Hi Sandra, to view DB Links you need access to SYS.DBA_DB_LINKS. to view Roles, you need access to SYS.DBA_ROLES, SYS.DBA_ROLE_PRIVS and SYS.DBA_SYS_PRIVS ...
Hi, We have started using AQT recently in our Mainframe shop. I am writing a batch compare script to compare a bunch of tables. I would like to know all the...
All these parameters relate to different options you see on the Compare Data window. The easiest thing to do is to set the various options in the window then...
We are getting an error that states, "Processing error at gui_load Invalid property value" and "Processing error at dbagui.setgui Invalid property value". I...
The most probable cause of this is that the remembered size/position of this window has somehow gotten bad values. The solution is to clear this out. Use...
What is the best way to use AQT with Java databases that dont install ODBC drivers, such as Derby and Hypersonic. Ive seen odbc-jdbc bridge software but seems...
Hi Satish, Yes, AQT is able to create and alter stored procedures for DB2. DB2 z/OS is an exception however as it doesn't hold the SP text in the catalog...
Hi Troy, Thank you very much for the information. I saw that SP information is stored in SYSIBM.SYSROUTINES_SRC for DB2 in z/OS. In Stored procedures developed...
Hi Satish, While there is a catalog table SYSIBM.SYSROUTINES_SRC this is only populated when SPs are created through the IBM Development Center. So this...
Good Morning, It seems that if I create a query and use quotes( " " ) for my column names, that when I use the query builder, the quotes are droped. Example 1)...
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.
