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 ?
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)