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.