-
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
-
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
-
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
-
I found it at http://www.vedit.com. This was a 30 day / 20 Days of use which every was greater trial version.
Gary
