how to handle Null values in FASTload

Database
Enthusiast

how to handle Null values in FASTload

Define
 colum (CHAR(19), nullif='                   '),
 colum2 (CHAR(35), nullif='                                   '),
 colum3 (CHAR(2), nullif='  '),
 colum4 (CHAR(4), nullif='    '),
 colum5 (CHAR(19), nullif='                   '),
 colum6 (CHAR(4), nullif='    '),
colum7 (CHAR(120),nullifzero='                                                                                                                        ')



Hi

Am loading unformatted(fixed width) data to teradata table using fastload table. But i got error like

Nullif value too long for column7. can some one help on this issue.

Thanks in advance.

4 REPLIES
Enthusiast

Re: how to handle Null values in FASTload

Sorry

for column7 also Nullif only.

Teradata Employee

Re: how to handle Null values in FASTload

FastLoad NULLIF supports a maximum of 80 characters.

Enthusiast

Re: how to handle Null values in FASTload

Can you try using a single space empty string  in all these nullif literals? 

Khurram
Enthusiast

Re: how to handle Null values in FASTload

Thank you Fred and saeed