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)...
Is there a setting change or other ideas to fix this? Thanks. ============================================ SETUP: Oracle field is varchar(2) length of 4000. ...
When your SQL goes into the Query Builder, it is parsed and turned into a graphical query. The SQL is then generated from the graphical query. The result is...
I'm not sure exactly what is going wrong here. In your TEST system, is the data OK? When you display the table you can double-click a cell (Detail of a Data...
The Oracle source for COPY - TEST Hex shows two positions 0D 0A (carriage return|line feed). The Oracle target after PASTE - PROD Hex shows one position 0A...
Thanks for that info. That helps to clarify this. When SQL is passed to Oracle, AQT does indeed replace cr+lf characters with lfs. In the past we have found...
The added option is working great!! (Option > Technical Parameters and de-select "For Oracle, replace CRLF with LF") Thank you so much for the OUTSTANDING...
My environment is AQT 8.1.6 on a Windows Server 2003 machine accessing Oracle 10g, SQL Server 2005, and DB2 databases. We upgraded directly from AQT 8.1.4 to...
Hi there, as for the first problem: when AQT retrieves SQL from the History, it parses the SQL to find the table(s) in it, then get the column-list for that...
Hi, I am having some difficulty finding out how to rename a table column using the alter table interface in AQT 8.1.5. No matter what DB I try to connect to,...
In the Admin Toolbar there is a little "tools" icon with a drop-down list. One of the items in this dropdown is "Rename columns". You will see this for...
Hi, I have a batch compare script that has all the parms set initially. I would like to keep all the parms in a different file, and use that file in my batch...
Hi, I had aqt 8.16 running fine for a long time under Server 2003 Service Pack 2 and on a VMWare virtual host. Our admins moved the virtual host with aqt to a...
The most probable cause of this is something called Data Execution Protection, that comes with MS Terminal Server 2003 SP2. This is a feature that is designed...
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.
