Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2009
    Posts
    4

    Unanswered:

    will sql*loader not convert from a packed decimal to a varchar field?
    i've tried EVERYTHING including TO_CHAR(TO_NUMBER options and it still won't work.

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    try decimal(precision,scale) in sqlloader. For example if the number of values past the decimal was 3 and the max length of the field was 10 you woul use decimal(10,3)
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Jun 2009
    Posts
    4

    i tried this before, but got same error

    the field is PIC 9(3) COMP-3 (remember COBOL?
    i put in DECIMAL(3) "("fieldname)" and got the same error

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2009
    Posts
    4
    I feel that i have the correct datatype definition according to this link
    I have decimal(3) "(:fieldname)"

  6. #6
    Join Date
    Jun 2009
    Posts
    4
    sorry, i figured out the problem
    our FTP to send our mainframe file to Oracle as a .DAT file was set up with the default of ASCII
    when my "357F" field was put on the .DAT file, it went on as "1E22" which is the EBCDIC version of the characters . and "
    oh, well!
    p.s. when i add BINARY as a control in my FTP cards, the .DAT file is CORRECT for this field, but unfortunately ALL the other fields become incorrect!

    thanks for everyone's input! seems i correct in how i defined the data off my mainframe flat file and not off the .DAT file out of my FTP

Posting Permissions

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