What is a good way to programatically set the schema in DB2?

You can use the DB2 SQL statement: db2 SET SCHEMA Also, you can deal with this statement to put it inside any code that connects to DB2, deal with this statement as any SQL statement.