Timestamp updated when gen_arg value changes?

Monday
Data warehouse developers are questioning why table's time_stamp value is not updated when value of gen_arg changes. Response is that gen_arg is used to provide a temporary sort order to on-line panels and is not worth tracking in a data warehouse. Within the Knowledge Warehouse documents, cannot find this topic addressed. Has anyone else addressed this?


Wednesday
Find out that the 2100-RESEQUENCE paragraph of csm programs that order data by gen_arg do update the value of time_stamp. Resequencing for tables TIDWOSTR and TIDWRSTR are special cases because the time_stamp value is used in the ORDER BY clause for ordering the data.

Reply