Re: Character conversion table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hilary Cotter (hilaryk_at_att.net)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 09:49:34 -0400

I know some people who are replicating to DB2 on AIX and are using IBM's
Open Direct (IIRC) driver to do so.

I am curious as to how you/they got the data from DB2/NT to DB2/AIX. Perhaps
something was translated incorrectly in this process. 

-- 
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Christian Dam" <badeanden@_no_spam_hotmail.com> wrote in message
news:eHj7TCeiEHA.140@TK2MSFTNGP12.phx.gbl...
> Yep, I know the MSdatatype_mappings but unfortunately that's not the one I
> was looking for. Your reply, however, have finally convinced me that table
I
> was told existed, actually do not exist.
>
> For a customer we have set up a replication from SQL Server 2000 to DB2.
> Originally the DB2 was located on Windows and everything worked fine. The
> customer then moved DB2 to AIX resulting in the line feed characters got
> transferred incorrectly, I'm guessing because of the differences between
NT
> and AIX (the LFCR vs. CR thingy).
>
> Unfortunately I don't have much additional information. It could look like
a
> ODBC configuration problem, but we don't even know if it is a line feed
> characters are transferred incorrectly if it appears within normal row
data.
> We are using the IBM DB2 ODBC driver version 7.01.00.88.
>
> Thanks
> /Christian
>
>
>
> "Hilary Cotter" <hilaryk@att.net> wrote in message
> news:%23$LROydiEHA.2764@TK2MSFTNGP11.phx.gbl...
> > its in the msdb database and its called MSdatatype_mappings. However,
this
> > doesn't really do what you are looking for. Its pure datatype mappings,
ie
> a
> > datatype in SQL Server to a datatype in access.
> >
> > Query this table to get an idea of what it actually does.
> >
> > I think what you want to do is to use a DTS transform to carry this form
> of
> > conversion out.
> >
> > What type of a database are you replicating to?
> >
> > -- 
> > Hilary Cotter
> > Looking for a book on SQL Server replication?
> > http://www.nwsu.com/0974973602.html
> >
> >
> > "Christian Dam" <badeanden@_no_spam_hotmail.com> wrote in message
> > news:ex8Mr%23aiEHA.2848@TK2MSFTNGP10.phx.gbl...
> > > Hi,
> > >
> > > I have been told a conversion table exist in either the master or the
> msdb
> > > database which can do a character conversion of data before it is sent
> to
> > a
> > > subscriber. I am not not talking about character set conversion but
> about
> > > the ability to modify named characters into another named character,
> e.g.
> > > chr(10)+chr(13) into chr(13).
> > >
> > > Does anybody know of such a table? I haven not been able to locate it.
> > >
> > > Cheers
> > > /Christian
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: UK IUG Meeting
    ... I have a question for you regarding High Availability Data Replication, ... How does Informix's feature set of replication ... and HA compare with DB2 HADR? ... verify the ER setup across all nodes in one go rather than starting ...
    (comp.databases.informix)
  • Re: Table Synchronization across databases on the same server
    ... > inhouse application which maintains a transactional database, DB2 also ... Since the DB1 is frequently updated the ... Anyway, I'm not very good at replication myself, I would encourage you to ...
    (comp.databases.ms-sqlserver)
  • Re: Is Xrc a reasonable solution between two databases created separately(in DB2)?
    ... Is Xrc a reasonable solution between two databases created separately(in DB2)? ... DB2 for z/OS itself supports linking multiple DB2s through DDF and DRDA. ... copying or replication don't actually need copying or replication, ...
    (bit.listserv.ibm-main)
  • Re: Push failed on New publication - error says owner may not exist or
    ... Looking for a SQL Server replication book? ... I create a new "Transactional" publication using the wizard. ... I want to subscribe to this publication, DB2. ...
    (microsoft.public.sqlserver.replication)
  • Re: Character conversion table
    ... For a customer we have set up a replication from SQL Server 2000 to DB2. ... characters are transferred incorrectly if it appears within normal row data. ... > datatype in SQL Server to a datatype in access. ... >> I have been told a conversion table exist in either the master or the ...
    (microsoft.public.sqlserver.replication)