EBCDIC conversion in SQLLOADER control file: S9(9)V format
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: EBCDIC conversion in SQLLOADER control file: S9(9)V format

  1. #1
    Join Date
    Jul 2000
    Posts
    41

    Unhappy

    We have an EBCDIC data file coming in with most fields as CHAR.. which load
    fine into an Oracle table using SQLLOADER. When we attempt to load a column
    that has a Cobol datatype S9(9)V and the control file has:
    LOAD DATA
    characterset WE8EBCDIC500
    infile 'CC4544.txt' "FIX 480"
    badfile 'CC4544BD.txt'
    INSERT
    into table KEVINS.TBLCF_STAGE
    ...
    ORACLECOL2 POSITION(66:74) INTEGER,
    ORACLECOL3 POSITION(75:76) CHAR,...
    the values that load into ORACLECOL2 have a leading minus sign and the numbers
    loaded aren't even close to the actual number.
    ie: ORACLECOL2 value should be: 044559987 and loads -159634259
    DDL of table shows ORACLECOL2 NUMBER(9,0)
    Summary: Trying to push a EBCDIC S9(9)V data field into ORACLECOL2 via
    SQLLOADER.

    Did anyone encounter this problem before? Please help.
    Thanks,
    CD


  2. #2
    Join Date
    Aug 2000
    Location
    Straham NH
    Posts
    73
    I had the same probem a while ago. I found an EBCDIC to ASCII convertor (editor) to use. It was free for a trial run. We needed as a one time use.

    Gary

  3. #3
    Join Date
    Jul 2000
    Posts
    41
    Do you remember what is the name of program that converts
    EBCDIC to ASCII where I could download it from ? I am in desperate need of help...

    Thanks,
    CD

  4. #4
    Join Date
    Aug 2000
    Location
    Straham NH
    Posts
    73
    I found it at http://www.vedit.com. This was a 30 day / 20 Days of use which every was greater trial version.

    Gary

Posting Permissions

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



Click Here to Expand Forum to Full Width