Home » RDBMS Server » Server Utilities » SQL*Loader: remove hexadecimal zero values
SQL*Loader: remove hexadecimal zero values [message #180438] Mon, 03 July 2006 09:01 Go to next message
zodiac_hh
Messages: 10
Registered: June 2006
Junior Member
Hi,

I'm trying to import some data from DB2 using SQL*Loader and a binary file dump. Some fields are supposed to be strings (DB2 CHAR), but they occasionally contain hexadecimal zero values, either full or partial. How do I get rid of these (in a easy and fast way Wink )? The trim function doesn't work.
At the moment these zeroes are imported into the database where they lead to errors in subsequent transformation steps.

Report message to a moderator

Re: SQL*Loader: remove hexadecimal zero values [message #180440 is a reply to message #180438] Mon, 03 July 2006 09:11 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>occasionally contain hexadecimal zero values
What is the difference between hexadecimal zero,
decimal zero, & character zero programatically?

Report message to a moderator

Re: SQL*Loader: remove hexadecimal zero values [message #180553 is a reply to message #180438] Tue, 04 July 2006 03:20 Go to previous message
zodiac_hh
Messages: 10
Registered: June 2006
Junior Member
hm, seems like i made a mistake in my control file. It does work with rtrim(myattribute, chr(0)).

Report message to a moderator

Previous Topic: Writting keyword to table
Next Topic: Exp and Imp BLOBs with out the exp-imp utility
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 04 19:23:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.