Re: sqlload problem (URGENT HELP)

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Wed, 24 Jan 2001 21:52:10 +0100
Message-ID: <3A6F407A.459AE0B5_at_0800-einwahl.de>


There is a newly introduced bug since 8.1.5 until 8.1.6.2.1 which is fixed in 8.1.6.3.0. If you load packed decimals from an EBCDIC source in conventional mode you get something like "invalid nibble".

Workaround: load in direct path.

Problem: if you use skip=..., the bug re-appears.

Workaround: work with Unix "dd".

Solution: use 8.1.6.3.0 or 8.1.7

Please do not crosspost.

Martin

chris_at_mail.snip.net wrote:
>
> I have a process which load a large binary file (~800MB) into 3
> tables. The process originally ran using sqlload v7.2.3 and ran with
> no problems. However I am trying to upgrade to v8.1.5 and I am now
> running into many problems. The problems seem to be focused columns
> loaded with the data using the packed decimal type. Does anyone out
> there have an answer to why this process that worked fine using
> sqlloader 7.2.3 now doesn't work using v8.1.5 ?
>
> Thanks.
Received on Wed Jan 24 2001 - 21:52:10 CET

Original text of this message