Archives of the TeradataForum
Message Posted: Tue, 04 May 2004 @ 13:34:37 GMT
For all fields that can have a NULL value you will need to COALESCE(FIELDNAME, '*') and then convert this field back to a NULL value when loading into another system... Use either NULLIF or CASE statements...
Using an * or other value that can be used in all columns is required and generally using a single value is best so you do not exceed column- lengths.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|