Becca,
to simply run a script through db2 the format is as follows, using the db2 clp.
db2 -f becca.ddl
where becca.ddl is the name of your file containing SQL commands.
There are a number of options for the clp, which you can query using
db2 list command options
There are two options you might be interested in the -r and -z.
-r saves the command output to a report file.
-z saves all output to an output file.
Haven't done enough experimenting to really be able to point out the major differences.
Alternative way of redirecting/logging output is along the lines of
db2 -f becca.ddl > becca.out
or to append
db2 -f becca.ddl >> becca.out
Should you choose not to redirect, output should be displayed on your standard output.
If you wish for comments in your becca.ddl file they need to begin with -- and the clp will effectively ignore them.
Cheers
Greg