Archives of the TeradataForum
Message Posted: Thu, 09 Apr 2009 @ 22:07:42 GMT
<-- Anonymously Posted: Thursday, April 09, 2009 17:51 -->
thanks for the reply.
I can use fastload or multiload, whatever works.
In the end I've used multiload, using the vartext format option.
In order to strip out the binary values I used
trim (both '01'XC from :columnA) , trim (both '01'XC from :columnB), etc
This worked remarkably well and will only present a problem if that data contains a comma.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|