If I have to DDL scripts, A, and B, is it possible to call script B from script A, and retain the current connection/user context?

Are they shell scripts or DB2 command scripts?

Andy

They're both DB2 command scripts. The desired architecture is to have one script that sets up the current schema and schema user, grants permissions, creates tablespaces, etc, and have that call out to others to create tables, etc, within the context of the same connection.

What DB2 version and OS are you using?

Andy

We have to support v9.7, on Windows & Linux primarily. Does the OS version impact the db2 CLI syntax?

I cannot think of a way to do it with normal DDL type scripts. Usually I would just use a shell script that ran the first script and then the second.

But with v9.7, you now have CLPPlus which may work for you. I have not used it yet as we are not totally on V9.7 yet.

Andy