Menu

#525 Auto export of SQL results to .csv or other format

SQuirreL
closed
nobody
None
5
2018-11-05
2015-10-28
No

To ease operations repeated every day, it would be very handy to have Squirrel SQL Client export the query results automatically to .csv (or other formats) without any interaction required. Either by setting some session parameters, or by scripting it in the query. Multiple queries can be run "in one go" by chaining them together with ; - so an auto export to indivudal files would open a new world for excel vba automation...

If it is possible to do so today, then I haven't been successful in finding the howto, please enlighten me. Using Squirrel SQL > 3.6 on DB2 databases.

Related

Feature Requests: #525

Discussion

  • sfst

    sfst - 2018-10-08

    I understand this is a duplicate of feature request #438?
    #438 Run query output to a file

     
    • Tom-Inge Nilsen

      Tom-Inge Nilsen - 2018-10-08

      Yes, seems like it is a duplicate. =)

      Den man. 8. okt. 2018 kl. 09:43 skrev sfst sfst@users.sourceforge.net:

      I understand this is a duplicate of feature request #438?

      438 Run query output to a file

      https://sourceforge.net/p/squirrel-sql/feature-requests/438/

      Status: open
      Group: SQuirreL
      Created: Wed Oct 28, 2015 01:47 PM UTC by Tom-Inge Nilsen
      Last Updated: Wed Oct 28, 2015 01:47 PM UTC
      Owner: nobody

      To ease operations repeated every day, it would be very handy to have
      Squirrel SQL Client export the query results automatically to .csv (or
      other formats) without any interaction required. Either by setting some
      session parameters, or by scripting it in the query. Multiple queries can
      be run "in one go" by chaining them together with ; - so an auto export to
      indivudal files would open a new world for excel vba automation...

      If it is possible to do so today, then I haven't been successful in
      finding the howto, please enlighten me. Using Squirrel SQL > 3.6 on DB2
      databases.


      Sent from sourceforge.net because you indicated interest in
      https://sourceforge.net/p/squirrel-sql/feature-requests/525/

      To unsubscribe from further messages, please visit
      https://sourceforge.net/auth/subscriptions/

      --
      Med vennlig hilsen

      Tom-Inge Nilsen

       

      Related

      Feature Requests: #525

  • Gerd Wagner

    Gerd Wagner - 2018-11-05
    • status: open --> closed
     
  • Gerd Wagner

    Gerd Wagner - 2018-11-05

    Closed because duplicate of feature request #438

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.