 |
 |
Archives of the TeradataForum
Message Posted: Fri, 20 Apr 2007 @ 13:25:19 GMT
| Subj: | | Re: SQL Functions in MLOAD Script.. |
| |
| From: | | Michael Larkins |
Raju:
TRIM is an SQL function in all databases. MLOAD does not do SQL in the .IMPORT. It does SQL in the .DML sections. From your example it
looks as if you are checking for a zero length character value. I do not believe there is such a thing in a character data field in a file
defined as TEXT. Should it not be a ' ' in your text data? It is not defined as VARTEXT so your column should be 10 bytes long. Otherwise
use you might benefit from using the NULLIF on the .FIELD.
Regards,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| |
