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:
infile 'CC4544.txt' "FIX 480"
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
Did anyone encounter this problem before? Please help.
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.
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...
I found it at http://www.vedit.com. This was a 30 day / 20 Days of use which every was greater trial version.
Click Here to Expand Forum to Full Width