473,396 Members | 1,773 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

determining codepage of a database

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

May 3 '07 #1
2 9575
Vivek,

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

Best regards,
Joachim Müller

"Vivek" <te*********@gmail.comschrieb im Newsbeitrag
news:11**********************@e65g2000hsc.googlegr oups.com...
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
May 3 '07 #2
On May 3, 7:38 pm, Joachim Müller <jom0...@douglas-informatik.de>
wrote:
Vivek,

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

Best regards,
Joachim Müller

"Vivek" <teaaswew...@gmail.comschrieb im Newsbeitragnews:11**********************@e65g2000h sc.googlegroups.com...
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- Hide quoted text -

- 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)

May 4 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Dmitry Davletbaev | last post by:
Hi! I use codepage 1251 to store data in MySQL tables. To support ORDER BY and LIKE on this data I must run MySQL server with "--default-character-set=cp1251" option. It's easy while I...
10
by: Christopher H. Laco | last post by:
Long story longer. I need to get web user input into a backend system that a) only grocks single byte encoding, b) expectes the data transer to be 1 bytes = 1 character, and c) uses the HP Roman-6...
8
by: Kim Bundgaard | last post by:
Hi Anyone know where I can look for problem with codepage conversion between DB2 UDB Connect EE V8.2 (fixpak 3) and DB2 UDB z/OS V7. With DB2 UDB Connect EE V7.2 (fixpak 7) i get Ebcdic X'5A'...
1
by: Vladimir Khvostov | last post by:
Hi, We have some DB2 table on the host that has varchar(3200) columns that are used to store binary data (I know that "varchar(3200) for bit data" should have been used, by modifying host table is...
0
by: bruce_pullen | last post by:
DB28.1 FP10 on AIX 5.3. SYSCAT.PACKAGES returns CODEPAGE=819 for certain packages. The database was created with CODEPAGE=1208. Should I be concerned? Thanks for any advice. Bruce
4
by: Ram | last post by:
Dear All, Good Day I am trying to convert a file which is generated on AS400 with codepage 00420 (arabic & English data combination) with no success. But using the same code( and changing 20420...
0
by: asklucas | last post by:
Hi there, I got an MS Access DB, which is causing problems when the client PC is running using a Traditional Chinese codepage. The DB was probably created with Access 97, Western European...
1
by: ssijakovic | last post by:
Hi, I don't know where to ask this question, and I hope this is the right group for this. I've made one ASP+Access site. On that site I have few parts where it's grabbing data from the...
0
by: Cuaracao | last post by:
This is my code: Code1: 'DoCmd.OpenTable "tblImport" 'DoCmd.TransferDatabase acExport, "dBASE IV", strOutputDir,acTable,"sel_TblImport", strDbfName & ".dbf", False ' DoCmd.Close acTable,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.