| SQL*Loader to Load EBCIDIC data [message #70062] |
Sun, 07 April 2002 23:59  |
meera
Messages: 5
Registered: February 2000
|
Junior Member |
|
|
Hi,
Can I user SQL*Loader to loader EBCIDIC data into the database. The version that we are using currently is Oracle 8.1.6 and also Oracle 9i
|
|
|
|
| Re: SQL*Loader to Load EBCIDIC data [message #70386 is a reply to message #70062] |
Thu, 06 June 2002 07:19  |
Eric
Messages: 78
Registered: April 1999
|
Member |
|
|
Yes, you absolutely can.
In you control file you can optionally set the characterset of the source. SQL*Loader worked like a charm.
Here is an example:
options (direct=true,errors=99999,rows=1000,bindsize=999000)
UNRECOVERABLE
LOAD DATA
CHARACTERSET WE8EBCDIC500
INFILE 'FORM.F1' "fix 1710"
REPLACE
INTO TABLE form ....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
