Character conversion error in cube

Posted on 2004-11-03
Last Modified: 2008-02-01
hi experts,

i encounter this error while processing cube:

[IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0332 - Character conversion between CCSID 835 and CCSID 37 not valid.;S1000; Time:11/2/2004 5:11:47 PM. the fact table is stored in AS400.

please help. thanks lots.
Question by:janelow
    LVL 8

    Accepted Solution

    In your ODBC connection have you checked "Convert binary data (CCSID 65535) to text" ?

    Author Comment

    hi SashP,

    thanks for the reply. i did as you suggested but the error is still the same.

    any idea?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now