How to get and change encoding schema for a DB2 z/OS database using dynamic SQL statement -
a db2 z/os database has been setup me. want know encoding scheme of database , change unicode if database other type of encoding. how can this? can using dynamic sql statements in java application? thanks! you need specify encoding scheme unicode when creating table (and database , tablepsace) using ccsid unicode clause. according documentation: by default, encoding scheme of table same encoding scheme of table space. default, encoding scheme of table space same encoding scheme of database. can override encoding scheme ccsid clause in create tablespace or create table statement. however, tables within table space must have same ccsid. for more, see creating unicode table in db2 z/os documentation . you able create tables via java/jdbc, doubt able create databases , tablespaces way. wouldn't recommend anyway, find closest z/os dba , person you.