Re: Trying to "SQLLOAD" COMP-3 fields.

I've to made a question.

Have you tryed to set NLS_NUMERIC_CHARACTER?

<rcarvalho1474_at_my-deja.com> ha scritto nel messaggio news:95d2gs$ql3$1_at_nnrp1.deja.com...
> I'm trying to use SQL Loader for loading an Oracle table from a Cobol
> generated file which has CHAR and COMP-3 fields and I always get the
> same error for all the input file's records.
>
> The table is defined as
> SQL> desc test_rescbsi1
> Name Null? Type
> ------------------------------- -------- ----
> NR_ACC VARCHAR2(16)
> NR_PHONE NUMBER(10)
> DT_CALL NUMBER(6)
> ....................
> ....................
>
> The file has the following layout:
> 01 rec-res.
> 03 acc_number pic x(16).
> 03 phone_number pic 9(10).
> 03 filler pic x(24).
> 03 call_date comp-3 pic s9(6).
> ..................................
> ..................................
>
> The control file defines the fields as:
> LOAD DATA
> CHARACTERSET WE8EBCDIC285
> INFILE 'cbsi1' "fix 350"
> BADFILE 'cbsi1.bad'
> DISCARDFILE 'cbsi1.dsc'
> INTO TABLE TEST_RESCBSI1
> (
> NR_ACC POSITION(01:16) CHAR,
> NR_PHONE POSITION(17:26) CHAR,
> DT_CALL POSITION(51:54) DECIMAL(6,0)
> )
>
> Whenever I try to load, I get the following message from SQL Loader:
>
> SQL*Loader: Release 8.1.5.0.0 - Production on Wed Jan 31 12:18:46 2001
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> Control File: cbsi1_2.ctl
> Character Set WE8EBCDIC285 specified for all input.
>
> Data File: reseller.cbsi1 File processing option string: "fix 350"
> Bad File: cbsi1.bad
> Discard File: cbsi1.dsc
> (Allow all discards)
>
> Number to load: ALL
> Number to skip: 0
> Errors allowed: 100
> Bind array: 64 rows, maximum of 65536 bytes
> Continuation: none specified
> Path used: Conventional
>
> Table TEST_RESCBSI1, loaded from every logical record.
> Insert option in effect for this table: INSERT
>
> Column Name Position Len Term Encl Datatype
> ------------------------------ ---------- ----- ---- ---- --------------
> -------
> NR_ACC 1:16 16 CHARACTER
> NR_PHONE 17:26 10 CHARACTER
> DT_CALL 51:54 4 PACKED
> DECIMAL (6, 0)
>
> Record 1: Rejected - Error on table TEST_RESCBSI1, column DT_CALL.
> Invalid zoned decimal nibble.
> Record 2: Rejected - Error on table TEST_RESCBSI1, column DT_CALL.
> Invalid zoned decimal nibble.
>
> (..... and so on for every record )
>
>
> Can somebody help me ?
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Feb 02 2001 - 08:52:54 CST