On 3 Jul 2003, cat wrote:
As long as the two fields are the defined with the same data type (and> Hi Folks,
> We are running DB2 UDB EE 7.2 on WIN2000. The project is migrating
> previous SQL Server 2000 to current DB2 Server using IBM MTK. It's a
> ERP system (JDE One World) with 6 databases,2000 tables for each
> database, totally 80G data.
> Our other major issue (we have opened a call with IBM regarding this
> problem) is in MS SQL Server we have a numeric value +080000 which
> massaged by the MTK the resulting field value is
> +8.00000000000000E+004 in
> the raw data. I realize that these to representation should be
> identical, however JDE OneWorld uses its own database engine and we
> would like to keep the data consistent.
> Does anyone know how to config MTK to overcome this problem or the way
> to covert numeric value +8.00000000000000E+004 to +080000 in DB2. Any
> suggestion will be appreciated.
it's not a character data type), then you're just seeing a difference in
how the database writes out the data in ASCII. The internal
representation of a number in the database won't matter to the
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
[url]http://www.newsfeeds.com[/url] - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----