Archives of the TeradataForum
Message Posted: Thu, 22 Nov 2002 @ 00:31:33 GMT
Subj: | | Re: Continuations in FastLoad |
|
From: | | Dwight Etheridge |
wgr,
You might defer the null check until values() clause. Since you appear to be an all or nothing check for low values, you may be able to
use TRIM.
,case when TRIM ( TRAILING '00'XCF FROM :IN_STR_ADR_LN_1 )=' '
then null
else :IN_STR_ADR_LN_1 End
I also have some SyncSort code around somewhere that can convert the low values to spaces before loading, if you want that.
Hope this may spark some ideas.
|