steinwaywhw/Readme.md

Last active August 29, 2015 14:05

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/steinwaywhw/a74fcb844e80c0990cdf.js"></script>
Save steinwaywhw/a74fcb844e80c0990cdf to your computer and use it in GitHub Desktop.

Download ZIP

Repeat a SQL multiple times

Raw

Repeat a SQL Multiple Times using `db2batch`

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

Reference:

Raw

	--#BGBLK 1000
	insert into MYTABLE values (int (rand () * 1000), 'someothervalue');
	--#EOBLK

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment