| Loading EBCDIC Data using SQL Loader [message #72832] |
Wed, 12 November 2003 04:26  |
Shikha
Messages: 36
Registered: January 2002
|
Member |
|
|
Hi,
I am trying to load EBCDIC data using SQL Loader.
What are the conditions/ parameters that differ than
regular ASCII load.
Does the following suffice?
CHARACTERSET WE8EBCDIC500
TIA,
Shikha
|
|
|
|
| Re: Loading EBCDIC Data using SQL Loader [message #72845 is a reply to message #72832] |
Sun, 16 November 2003 12:47  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
You can specify the INFILE's character set in the loader
control file. Data will be converted from the specified
character set to the database's character set. Look at this
code fragment used to load EBCDIC data:
LOAD DATA
CHARACTERSET 'WE8EBCDIC37C'
INFILE 'ebcdic.dat'
...
See chapter 5 of the "Oracle9i Database Utilities" guide
(SQL*Loader Control File Reference) for more information.
Best regards.
Frank Naude
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
