Larry, I just tested this. The username survives the reload, as my
admittedly ancient memory cells reminded me. As the column is not null
when the reload takes place, the value remains unchanged.
Lawrence Lustig wrote:
<<
(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
