Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    4

    Unanswered: Import table - sign problem

    Hi,

    I have imported a table from Oracle to SQL server using the tool in enterprise manager.

    Some of the columns were numeric and had negative values.

    In Query analyzer these numbers show up as positive. But when i add a where clause and only ask for the values < 0 the same numbers show up bit still without a negative sign.

    Does anyone have an explanation for this?
    (could have found some help if the search function was working....)

    Workaround?


    Thanks,
    YakoBay

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Bizarre...Is it a setting?

    Code:
    CREATE TABLE myTable99(Col1 decimal(15,4))
    GO
    
    INSERT INTO myTable99(Col1) SELECT -123.4567
    GO
    
    SELECT * FROM myTable99
    GO
    
    DROP TABLE myTable99
    GO
    EDIT: what did the Column datatype transform as?

    I assume you used DTS....

    Why not use PL/SQL to export the data then bcp the data in?

    Also what version of Oracle?

    Did the EVER come up with an unload utility?
    Last edited by Brett Kaiser; 05-24-04 at 10:24.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    May 2004
    Posts
    4
    Found a working solution.

    I was using the ODBC connection to get the data via DTS Import.

    When testing with datasource = Oracle Provider for OLE DB the numbers was correct!

    YakoBay

Posting Permissions

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