Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 20 Apr 2007 @ 13:25:19 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023