Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Problem with ZOned data type

    Hi ..
    I am working with SQL loader.
    I have a .CTL file with datatype zoned(4,2)
    and my .DAT file has 1111

    i can see in my table of oracle the value entered as 11.11

    now how should i insert negative value.

    if i write in .dat file 1111- it throws error.
    can someone pls help me with it.
    its urgent!!

  2. #2
    Join Date
    Apr 2003
    Greenville, SC (USA)
    The last time I had to load zoned data, I used : ex:

    Charge Position (251:260) Zoned (10)

    and I believe I got positive and negative with this


Posting Permissions

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