Running Multiple SQL Scripts Automatically

Toad for IBM DB2
1

Hi, I am new to DB2 and TOAD, so a complete novice here. I need to run around 100,000+ stored procedures to import data into my DB2 database. I tried to run them by copying into the TOAD query editor, but i receieved a memory exception error. Therefore, I have created a number of text files which contain SQL statements. Due to the nember, i do not want to run these manually, plus operations will not allow this, therefore, i need a way to automatically run all of the scripts. I was hoping that I coupld create a directory, place the the text files within it, then have a sinlge file that i can call which will run all of the scripts in turn.

Is this possible to do with TOAD for DB2?

Thank you in all in advance

2

You might find something you could use here.

toad.henrik.org/…/flow-control-for-your-scripts.html

Specifically look for the INCLUDE command. That way you should be able to create one script that references all your other scripts and then execute that.