sql*loader

From: <djsande_at_my-deja.com>
Date: 2000/06/21
Message-ID: <8iqlc4$48u$1@nnrp2.deja.com>#1/1

having the following problems trying to load a test file with sqlload. I don't have access to the server. Does anyone have any idea what's going on here?

Dan.

--SQL*Loader-282: Unable to locate character set
handle for character set ID (0).

LOAD DATA CHARACTERSET WE8EBCDIC500
--F7DEX
--US7ASCII
--WE8DEC
--WE8HP
--WE8ISO8859P1
--WE8EBCDIC500

INFILE * "FIX113"
INTO TABLE LEGACY.TESTLOC (

"LOCATION"      POSITION(*) CHAR(20),
"DESCRIPTION"   POSITION(*) CHAR(65),
"LO1"           POSITION(*) CHAR(20),
"LO2"           POSITION(*) CHAR(8)

)
begindata
BAL1PA ALLEN 1 - MARTIN LOW PRESSURE SYSTEM

BLOCKWELLS          WELL
BAL1PACOMP          ALLEN 1 -
COMPRESSOR
     BAL1PA              COMP
BAL1PADH            ALLEN 1 - DOWN
HOLE
BAL1PA              DHOLE

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jun 21 2000 - 00:00:00 CDT