Danny,
Not sure if you have ever run into this but looks like AQT won't export CLOBs from an archive.
This is the exact error message.
Export failed with error during Fetch
S1000(31)[IBM][Optim Connect Driver for ODBC 3.5]The length of the buffer (%d) is less than of the received data chunk (%d)
(1.11 secs)
I used
www.lipsum.com to generate a 21,000 byte text block and inserted it into an Oracle test table. AQT had no issue with an export from the table. I confirmed the archive of the CLOB matched the source. However when trying to export from the archive file it failed. AQT must be sensitive to something in the Optim Connect driver. DBVis can handle the export of a CLOB in the archive file.
I'll continue to play with it but it doesn't look like there is a way around this issue. That being said this is still a super nice product for working with the different DBMS!
------------------------------
Donna Simmons
Application System Engineer
------------------------------
Original Message:
Sent: Tue April 21, 2020 02:59 PM
From: Donna Simmons
Subject: Query Archives without DBVisualizer
Thanks Danny for the picture! I confirmed I see the objects for database connections. If I choose an archive connection nothing appears under tables and views. Is that your experience too? DBVis can display the tables and column information inside of an archive file which is a nice feature.
Thanks again for recommending AQT!
------------------------------
Donna Simmons
Application System Engineer
Original Message:
Sent: Tue April 21, 2020 09:02 AM
From: Danny Lankford
Subject: Query Archives without DBVisualizer
HI Donna,
No tree expansion twisty. When an object is selected in the pane, it becomes expanded on the window to the right.
I don't believe that there is a config setting to change this behavior to look like say... SQL server client, MS SQL Studio Management client.
See the screen capture.
Danny L. Lankford | IT Manager
Original Message------
Danny,
Thanks for recommending AQT. Seems like a solid piece of software. I was able to create an ODBC connection and query a test archive file!
Quick question: In the Database Object pane I see my DefTdpName name. Below that name are two subcategories; Table and Views and System Tables. However they don't expand. I was hoping I would expand and see the table names in the archive file displayed in the GUI. Does your setup allow you to see the tables in the archive? This isn't a deal breaker but was curious if there was a setting that I needed to flip.
Thanks again,
Donna Simmons
Application System Engineer
------------------------------
Donna Simmons
Application System Engineer
------------------------------
#InfoSphereOptim
#Optim