Just enclose the SQL statements within --#BGBLK
and --#EOBLK
and feed it with a repeat-count as shown in input.sql
.
Then run
db2batch -n DATABASE_NAME -f input.sql
Just enclose the SQL statements within --#BGBLK
and --#EOBLK
and feed it with a repeat-count as shown in input.sql
.
Then run
db2batch -n DATABASE_NAME -f input.sql
--#BGBLK 1000 | |
insert into MYTABLE values (int (rand () * 1000), 'someothervalue'); | |
--#EOBLK |