Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2012
    Posts
    23

    Unanswered: Need help for execution of scripts

    Hi,

    We are using DB2 9.7 on Linux 5.5 version.Actually we have some oracle scripts around 40 which all starts with @ the same we have to execute into the DB2 environment all at a time.could you please suggest me what is the command we have to use for the same.

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    db2 -tvf your_script_file
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    Aug 2012
    Posts
    23

    Need help for execution of scripts

    Hi alfor,

    You are right based on your reply it is only the way for which we have to execute the single script alone.but here my requirement is we have to execute multiple scripts at a time not one by one hope you understood.Please do the needful.........

  4. #4
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    I work on Windows, so I would write a batch file that will read all the script files from a given folder and, for each one of them, will cal db2 -tvf script_file.
    I'm pretty sure you can achieve something similar on Linux.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

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