Hi

I was using Oracle earlier and I had an .sql file which calls multiple other .sql files located in various folders.

Example:
DB-CREATE.sql has:

prompt creating tables
@tables/tables.sql

prompt creating sequences
@sequences/sequences.sql

And inside tables.sql, I have:
@@TABLE1.sql
@@TABLE2.sql ..etc

And from PL/SQL prompt, I execute DB-CREATE.sql and it in turns executes all the files.

How can I achieve the same in DB2 command line processor?

Thanks,
Sriram