IBM DB2 Driver for ODBC and CLI connection strings

IBM DB2

Standard

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

Database Alias

Driver={IBM DB2 ODBC DRIVER};DBALIAS=DatabaseAlias;Uid=myUsername;Pwd=myPassword;

Try this dbalias alternative if the database keyword does not work.

Specifying schema

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"