SPECIFY the character set WE8EBCDIC500 for the EBCDIC data.

The following EXAMPLE shows the SQL*LOADER controlfile to load a fixed length EBCDIC record into the Oracle Database:

LOAD DATA

CHARACTERSET WE8EBCDIC500

INFILE data.ebc "fix 86 buffers 1024"

BADFILE data.bad'

DISCARDFILE data.dsc'

REPLACE

INTO TABLE temp_data

(

 field1 POSITION (1:4) INTEGER EXTERNAL,

 field2 POSITION (5:6) INTEGER EXTERNAL,

 field3 POSITION (7:12) INTEGER EXTERNAL,

 field4 POSITION (13:42) CHAR,

 field5 POSITION (43:72) CHAR,

 field6 POSITION (73:73) INTEGER EXTERNAL,

 field7 POSITION (74:74) INTEGER EXTERNAL,

 field8 POSITION (75:75) INTEGER EXTERNAL,

 field9 POSITION (76:86) INTEGER EXTERNAL

Specify the character set WE8EBCDIC500 for the EBCDIC data.

The following example shows the SQL*Loader controlfile to load a fixed length EBCDIC record into the Oracle Database:

LOAD DATA

CHARACTERSET WE8EBCDIC500

INFILE data.ebc "fix 86 buffers 1024"

BADFILE data.bad'

DISCARDFILE data.dsc'

REPLACE

INTO TABLE temp_data

(

 field1 POSITION (1:4) INTEGER EXTERNAL,

 field2 POSITION (5:6) INTEGER EXTERNAL,

 field3 POSITION (7:12) INTEGER EXTERNAL,

 field4 POSITION (13:42) CHAR,

 field5 POSITION (43:72) CHAR,

 field6 POSITION (73:73) INTEGER EXTERNAL,

 field7 POSITION (74:74) INTEGER EXTERNAL,

 field8 POSITION (75:75) INTEGER EXTERNAL,

 field9 POSITION (76:86) INTEGER EXTERNAL