Professional Web Applications Themes

extraction of numeric values question (HELP) - IBM DB2

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 when 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 ...

  1. #1

    Default extraction of numeric values question (HELP)

    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
    when
    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.

    Regards

    Cat
    cat Guest

  2. #2

    Default Re: extraction of numeric values question (HELP)

    On 3 Jul 2003, cat wrote:
    > 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
    > when
    > 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.
    >
    As long as the two fields are the defined with the same data type (and
    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
    application.


    Good luck,



    -----= 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! =-----
    Ian D. Bjorhovde Guest

  3. #3

    Default Re: extraction of numeric values question (HELP)

    Thanks Ian, but as I said. As I said, JDE OneWorld uses its own
    database engine and it might cause the problem if we change the db2
    data type format. I am sure DB2 must have some method to change its
    numeric format.

    Regards

    Ingrid




    "Ian D. Bjorhovde" <ianbjormobileaudio.com> wrote in message news:<Pine.LNX.4.44.0307030647210.28192-100000sidi.phx.dataproxy.com>...
    > On 3 Jul 2003, cat wrote:
    >
    > > 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
    > > when
    > > 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.
    > >
    >
    > As long as the two fields are the defined with the same data type (and
    > 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
    > application.
    >
    >
    > Good luck,
    >
    >
    >
    > -----= 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! =-----
    cat Guest

Similar Threads

  1. Getting the values of a series of numeric steppers
    By Steve L in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: July 12th, 06:36 PM
  2. Numeric values
    By plaustrum in forum Coldfusion Database Access
    Replies: 2
    Last Post: January 8th, 12:50 PM
  3. How to convert timestamp values to numeric (SQL70)
    By Russell Fields in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 8th, 10:09 PM
  4. Replies: 2
    Last Post: July 7th, 04:02 PM
  5. Enumerators - Replace Numeric Values with Text
    By Lucas Tam in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 4th, 12:16 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139