<<
(IFNULL(UserNameCol,(CVAL('USER'),UserNameCol))
It will then only update when it is null with the current user name.
>>
The problem with this technique is that the data does not survive across an
UNLOAD / RELOAD. For instance, consider a table with two columns:
(IFNULL(UserNameCol,(CVAL('USER'),UserNameCol))
(IFNULL(UserNameCol,(.#DATE,CreateDateCol))
UNLOADing and LOADing this table will result in all the user columns having the
name of the user who reloaded the data, and all the columns having the date of
the reload -- losing the original data.
--
Larry
