473,387 Members | 1,890 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,387 software developers and data experts.

Exporting dbcs character in db2

There is a script for data export from db2 to cvs files. It is currently working fine on one AIX machine but not on another. The problem I am facing is -- DBCS characters are visible in Command Center but they are coming as junk character in the exported CSV file.

DBCS (Double Byte Character Set) characters are double byte characters like chinese, japnese, korean, Hindi, etc. For example "公" .
Apr 19 '07 #1
1 2074
aha42
1
Try CVSNT a cvs variant with unicode support.
Apr 26 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...
0
by: Ranjith | last post by:
Hi, I have got a problem of DBCS enabling a CICS-COBOL-DB2 application. I have identified some steps that need to be done to DBCs enable DB2. Some of them like 1) Changing the settings in...
1
by: Odd Bjørn Andersen | last post by:
When exporting character data with column length greater than 254, the data is truncated. For some reason I have to export the data in DEL format. Is there a way to avoid the truncation of data ? ...
2
by: ASIF | last post by:
Does anyone klnow of a quick way of exporting data from access to a text doucument, the data needs to be tab seperated, and the data to be exported needs to be selected using parameter queries. I...
5
by: PC Work | last post by:
I am using code to export a database to a text file in ms access 2002 Not matter what export method I choose, a field name with a # in it exports to a period. so a field name caled '# of items'...
2
by: bienwell | last post by:
Hi, I have a question about exporting data from datagrid control into Excel file in ASP.NET. On my Web page, I have a linkbutton "Export data". This link will call a Sub Function to perform...
0
by: Richard G. Riley | last post by:
I'm looking for some pointers on unicode/dbcs systems in C : specifically general advice on maintaining cross platform/language dependance and lists of standard functions which may be used. Any...
13
by: GavReynolds | last post by:
Hi All Im new to this site so please beer with me.... I am using MS Access to export the value of a query to an xml file. This works fine...however, there seems to be a 255 character maximum on...
0
by: chandurp | last post by:
Hi, Is it possible to give DBCS/Unicode characters for the user name on db2? I tried of give Unicode characters username for db2 installed on Windows (language-English), but failed to add user....
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
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
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
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
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.