Results 1 to 2 of 2

Thread: isql help

  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: isql help

    Hi,

    I need to execute a series of Sql statements that are split across different files. I am currently using a batch process(with scheduler) to execute one isql command one for each input file. But i feel this is not the right approach as i am creating a database connection everytime i need to process a file. Files are generated at runtime and hence i cant merge all of them into one and execute as well. Please let me know a solution for this

    Thanks in advance
    Badri
    Last edited by badrirulzs; 02-17-04 at 08:13.

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Concatenate all your SQL files before executing the isql.
    Are you using unix or Win ?
    Else you can use :r file.sql from an opened isql session

Posting Permissions

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