Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4

    Unanswered: multiple SQL commands in Command Center

    When I submit more than one SQL command at once in Command Center, only the first one is executed.

    In Tools Settings I selected
    x Use statement termination Character ;
    But that didn't help.

    It's very cumbersome to copy-and-paste each and every SQL command separately to Control Center to create and maintain a large databse.

    Please help.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I remember there used to be a 'Script' tab in the older versions of the command centre


    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Apr 2004
    Posts
    22
    Maybe you can use
    db2sql92 -d YourDB -a Account/Password -f test.sql

    or
    db2 -tvf test.sql
    **************************************
    Make progress everyday
    Mail: hoo.jimmy@gmail.com
    **************************************

Posting Permissions

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