I need to connect to the db (created with "IBM-943" codeset) on DB2 AIX . I am having a problem retrieving data with japanese character in 'where' clause something like this.

SELECT * FROM \"TEST\".\"TABLE1\" WHERE COL2 like '%㈱%'

It returns nothing. So I want to try to set the codepage(the same code page that db uses) in JDBC level to see if it retrieves something.

Here is what I am trying. But I am not sure if I am using valid properties.
String driver = "com.ibm.db2.jcc.DB2Driver";
String url = "....";
String username = "demouser";
String password = "demouser";
java.util.Properties prop = new java.util.Properties();
prop.put("user", username);
prop.put("password", password);
prop.put("DB2e_ENCODING", "IBM-943");
prop.put("codepage", "943");

Class.forName(driver);
com.ibm.db2.jcc.DB2Connection conn = (DB2Connection)DriverManager.getConnection(url, prop);

Does anybody know what the correct properties name is?

Thanks.