Message-ID: <3A7A652A.F1F8C030@yahoo.co.uk>
From: Gordon Cartwright <gordon_cartwright@yahoo.co.uk>
Reply-To: gordon_cartwright@yahoo.co.uk
Organization: Springwood Computing Ltd
X-Mailer: Mozilla 4.61 (Macintosh; I; PPC)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Trying to "SQLLOAD" COMP-3 fields.
References: <95d2gs$ql3$1@nnrp1.deja.com>
Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854"; x-mac-creator="4D4F5353"
Content-Transfer-Encoding: 7bit
Lines: 85
Date: Fri, 02 Feb 2001 07:43:38 +0000
NNTP-Posting-Host: 62.255.108.81
X-Complaints-To: abuse@virgin.net
X-Trace: news6-win.server.ntlworld.com 981099807 62.255.108.81 (Fri, 02 Feb 2001 07:43:27 GMT)
NNTP-Posting-Date: Fri, 02 Feb 2001 07:43:27 GMT


I think this is a bug in the conventional path loader. Try direct=y on the
command line.

rcarvalho1474@my-deja.com wrote:

> 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/