I have created a db userid wih limited security access. When the user connects to the db via AQT, he can see the tables in the appropriate folders in the left...
Hi, Is there a way to export to Insert Statements multiple tables at once (in the same file)? It is already possible to do it, but only one table at a time. ...
The queries that AQT runs to populate the Database Explorer for SybaseIQ are held in file sybasea.cfg. In the case of the Columns display, the user requires...
No, this is not possible. All the data goes to a single table. Are you exporting from a join, and want the data to go to the different tables in the join? One...
What I would like to be able to do, is select a bunch of tables, and then having the possibility to export the data in those tables to a file, and outputing...
I think you can do it like this: Run the sql for one table. The choose File -> Export results (or F7). For the first table choose output as INSERTs and File...
This method is ok if you only have a couple of tables. But I have to deal with around 75 tables... In a developement cycle, when you are moving data often in...
You can do this as follows: a) in the Database Explorer, ensure you have a list of tables in the middle pane b) go Tools > Generate Text (or the "yellow" icon...
I had previsouly locked the admin component from within the application, greying out the bar from use. We have recently changed the ODBC drivers for use with...
There is a problem looking at indexes in AQT version 6.1.6 using DB2 version 7 on ZOS. When you click on any index owner name in the index portion of the...
What connect parameters/format do I need in order to connect via batch with AQT using an ODBC driver from Openlink? We connect to other packages using this...
I am getting some unexpected results comparing schemas from one DB2 database (V8.1) to another DB2 database (V8.2). It is coming back stating that a Table in...
Haven't used "Openlink" but here is a script I use with the Datadirect drivers and a Progress DB. Not sure if this will help or not; but I simply give it the...
Your connect should be: --aqt connect,Conn="Driver=C:\OPENLINK\oplodb32.dll;DSN=gogdbm; Database=gogdbm;UID=;Pwd=;" Eg. two minus signs before aqt, and the...
This can happen if your two databases have different collating sequences. AQT gets the information on your tables with the following query run against each...
I have just started to work with Advantage Database Server and quite like using AQT over their Advantage Data Architect for the pure ease of browsing the...
Hi All, I am new to AQT tool.Can someone tell me how to see the output of DBMS_OUTPUT.put_line used within a stored procedure.The procedure seems to be...
I have a batch file with output type=insert that works fine. type=insert in non batch mode will prompt for table and max line length. Can I force the prompt...
... of DBMS_OUTPUT.put_line used within a stored procedure.The procedure seems to be executed.But I cannot see any output.Is there any command ... If this is...
No, Oracle is a bit different than Sybase. The DBMS_OUTPUT goes to an Oracle system buffer; it can only be seen if you run some PL/SQL code to retrieve it. AQT...
This currently a limitation, which I have fixed in AQT v6.1.7. This has a parameter maxlen=xxx in which you can specify this. You can also do a Generate Batch...
This is slightly odd. Could you send a screenshot (to phil@querytool. com) so I can see what it looks like. Also, a debug file (Options > General Options)...
When logged into AQT, at the bottom of the screen there are small boxes identifying what database you will go to when you click it. It also has an icon of a...
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.
