Archives of the TeradataForum
Message Posted: Thu, 15 Jun 2006 @ 14:43:02 GMT
Subj: | | Re: Equivalent of FastLoad NULLIF in USING |
|
From: | | Michael Larkins |
Anomy:
The "USING" modifier is part of SQL and NULLIF is a Fastload, Mload and TPump feature - no correlation between them.
Another post recommended using INDICATORS on the IMPORT. That is all well and good if the file is created with INDICATORS on the EXPORT. If
you try to import data without indicators as indicdata/INDICATORS you will run into problems. If you don't have indicators or can't create them
using BTEQ or FastExport, then I suggest you use one of the other utilities.
Regards,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
|