From command window(invoked using a db2cmd command), if you meant this one, the most common is
db2 -tvf <scriptname>
t - default delimiter ;
v - verbose
f - input file
More options are detailed in the comman reference manual.
From Command Centre, go the the Scripts tab ... If you have a file , you can import it into the comman centre , or you can create a new one and run it using the 'gear-wheel' icon or script->execute menu option.
If you do not intend to edit the scitpt, I recommend using Script Centre, which allows you to see and manage multiple scripts, both db2 and os commands ...
My choice is using the command window (I hate db2's gui tools ... they eat up your system memory and response time is high ) ...
Originally posted by k_sekhar_rao
This may be a silly question, but any way. Can any one tell me how to run a ddl file or sql file in CLP and command center.