Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Posts
    5

    Unanswered: Possible to connect/loop through databases using iSQL?

    Hi,

    I'm working with servers connected on Sybase Central (SQL Anywhere 11). I'm connected to a few DBs, and there's a query I want to get from each one. I have the SQL code so that I can output the query, but is there a way I can loop through the DBs so that I output the query from each DB into one file? My main concern is connecting/looping through each DB, not how can I get the output. I know you can use CONNECT USING '[connection_string]'. Any steps from there, or is there another way to approach this?

    Thanks!
    Last edited by kickdrum; 11-20-12 at 10:57.

  2. #2
    Join Date
    Oct 2012
    Posts
    8
    You can write batch script/shell script as per the platform. Thanks,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •