Specifying schema using IBM DB2 ODBC DRIVER

Connection string

This IBM DB2 Driver for ODBC and CLI connection string can be used for connections to IBM DB2.

Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;
Port=1234;Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;CurrentSchema=mySchema;

Using this you can use "select from myTable" instead of "select from mySchema.myTable"