 |
 |
Archives of the TeradataForum
Message Posted: Tue, 20 Dec 2005 @ 14:24:02 GMT
| Subj: | | Re: NULLS to Spaces |
| |
| From: | | Michael Larkins |
If you are thinking about recreating the table, instead of selecting each column with a coalesce, you can create the table with a constraint of
DEFAULT SYSTEM. Meaning that when a null comes into the column and it is character it will automatically store a space or zero when numeric.
Then you can add the attribute of compress ' ' or compress 0 on the column and the storage requirements should be the same as compressing null.
Plus it guarantees that a null will never be stored accidentally in the future.
Hope this helps,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| |
