Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009

    Unanswered: db2batch in repeat mode

    Does db2batch command have the ability to run each statement in the input file more than one time ? If so, can some one give the command to do it ?

    Right now I am using

    db2batch -d dbname -f inputfile -r outputfile

    But I want the sql statements to be executed 10 times. I think there is an option but I am not able to figure out the exact command from info centre... can someone please help me out ?

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Put a block in the input file, as described in the db2batch help:

    --#BGBLK [repeat_count] (start of a block of queries)
    --#EOBLK (end of a block of queries)
    "It does not work" is not a valid problem statement.

Posting Permissions

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