determining codepage of a database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vivek - 03 May 2007 15:25 GMT

Hi,

How can i determine the codepage of a database from a CLI (or embedded
SQL) program ? Is there a catalog table that i can query for this
information ?

Thanks

Reply to this Message

Joachim Müller - 03 May 2007 15:38 GMT

Vivek,

For DB2 9 use 'select * from sysibmadm.dbcfg' and see what you need.

Best regards,
Joachim Müller

> Hi,
>
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

Vivek - 04 May 2007 09:40 GMT

On May 3, 7:38 pm, Joachim Müller <jom0...@douglas-informatik.de>
wrote:

> Vivek,
>
[quoted text clipped - 12 lines]
>
> - Show quoted text -

Thanks Joachim. Is there an equivalent way for DB2 8 ? I see that i
can get the codepage (as a number) from syscat.datatypes ? Is there a
way to map this to a codeset (i.e. codepage as a name)

Reply to this Message