|
|
Archives of the TeradataForum
Message Posted: Wed, 16 Mar 2005 @ 14:49:55 GMT
Subj: | | Re: MLoad & Removing Binary Zeros |
|
From: | | Michael Larkins |
Just a thought:
Donald has made some good suggestions. As another thought and I have not ever tried this but, If I were in your situation I would also try
using the NULLIF '00000000'xb on the fields that are causing you the problem. Again, I have never used this technique with a VARTEXT field
definition but what have you got to lose?
Hope this helps,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| |