Topic Thread

Expand all | Collapse all

Query Archives without DBVisualizer

  • 1.  Query Archives without DBVisualizer

    Posted 9 days ago
    Has anyone in the IBM Community used something other than DBVisualizer to query the archives? Primarily we use it to extract BLOBs into separate files. Was wondering if anyone had success using any other product.

    Thanks!
    Donna Simmons
    Wells Fargo, Applications Systems Engineer




    ------------------------------
    Donna Simmons
    ------------------------------


  • 2.  RE: Query Archives without DBVisualizer

    Posted 9 days ago
    I'm a fan of AQT Advanced Query Tool. http://querytool.com/index.html It also comes in handy as a multi-database tool. JDBC/ODBC File DSN, Weird Direct Connect stuff, Etc. The v10 with extended features is awesome.

    ------------------------------
    Danny Lankford
    3M - IT Manager
    ------------------------------



  • 3.  RE: Query Archives without DBVisualizer

    Posted 9 days ago

    Thanks Danny! I will definitely take a look at this one. Quick question: Can this product be setup to create separate files for each BLOB in a record?






  • 4.  RE: Query Archives without DBVisualizer

    Posted 9 days ago
    Yes. http://querytool.com/features/tour4.html#lobs look at the features link. you can export *LOBs to files or view them right in the AQT tool. pretty handy. There's some cool export functions to script the exports as well.

    ------------------------------
    Danny Lankford
    3M - IT Manager
    ------------------------------



  • 5.  RE: Query Archives without DBVisualizer

    Posted 8 days ago
    ​Impressive! I don't believe DBVisualizer offered the ability to view LOBs in their tool. I'm reviewing the AQT Feature comparison list and it looks like the Display Data, including LOB columns is part of the Standard version. Thanks for the suggestion!

    ------------------------------
    Donna Simmons
    Application System Engineer
    ------------------------------



  • 6.  RE: Query Archives without DBVisualizer

    Posted 7 days ago
    Not sure if I understand the question / thread correctly, but DBVisualizer can view LOBs in their tool ; just do a normal select (that can include LOB fields) , and for a record, double click on the LOB field, and it will 'try' and make it readable. Also, when f.i. exporting the full result set to an excel format, it will make the LOB's readable in the generated excel sheet.

    ------------------------------
    Erwin Hattingh
    Systems Engineer / Db2 DBA
    Triodos Bank
    ------------------------------



  • 7.  RE: Query Archives without DBVisualizer

    Posted 6 days ago

    Hi Erwin! My first question was to find an alternative to DBVisualizer to query the archives. You make a good point that DBVisualizer can display LOB information and it will do its best to make it readable. The feature Danny shared in his post was that AQT can open the image file (if that is what is in the LOB) in the tool also. http://querytool.com/features/tour4.html#lobs

     

    Another feature I used in DBVisualizer was the ability to export LOBs to separate files. AQT has same feature http://querytool.com/features/tourexport.html and also offers a linked-to in the main export results. They have an example of how the linked-to feature works here http://www.querytool.com/photos.html.



    ------------------------------
    Donna Simmons
    Application System Engineer
    ------------------------------