Enclosed example can help you in this regard:
db2 connect to %1 user %2 using %3
db2 set schema STAGING
echo ==== CREATING TABLES ====
cd DDL
db2 -stvf create_table.ddl
echo Exit code from CREATING TABLES: %ERRORLEVEL%
echo ==== CREATING EVERYTHING ELSE ====
db2 -stvf everything_else.ddl
echo Exit code from CREATING EVERYTHING ELSE: %ERRORLEVEL%
cd ..
Jayanta Datta
Xansa India