Re: sqlldr hex numbers into raw datatypes

From: Kay Kanekowski <kkanekowski_at_mindcommerce.de>
Date: Thu, 12 Jul 2001 11:56:04 +0200
Message-ID: <9ijsh8$v0u$1@fermi.tro.net>

Hi,

have you try someting like rawtohex ...

On a OS/390 i had the problem of packed bytes. After a long day with endless tries this one worked, but i don't really know why.
- The AND-clause X'00' identified an empty byte on the host, i think...

• The number/substr cuts the information for my problem

INTO TABLE gem05_t1_kk

   WHEN wl003 = '1030'                -- Satzart 1030 WLN

    AND (26:26) <> X'00'
(

 wl002 POSITION (2:5)   ZONED(4),       -- auf Pos gesetzt
 wl003                  ZONED(4),
 wl005 POSITION (26:30) CHAR(5)  "to_number(substr(rawtohex(:wl005), 2, 8))",
 wl006                                 CHAR(3)  "to_number(substr(rawtohex(:wl006), 1, 5)) / 100"

)

hth
Kay Kanekowski Received on Thu Jul 12 2001 - 04:56:04 CDT