NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
3 replies Latest Post - 2013-01-10T15:06:09Z by SystemAdmin
Pinned topic Is rand_lookup only valuable for CHAR / VARCHAR type?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Is rand_lookup only support CHAR / VARCHAR type field?
Updated on 2013-01-10T15:06:09Z at 2013-01-10T15:06:09Z by SystemAdmin
Re: Is rand_lookup only valuable for CHAR / VARCHAR type?2013-01-09T13:22:14Z in response to sbjerryHi sbjerry,
RAND_LOOKUP will lookup from a source that you specify and return replacement values from a column (or columns) that you specify. So, if you are looking to replace a DATETIME column with something random from a lookup table, create the lookup table with a type of DATETIME.
For flexibility between source and target, refer to the Common Elements Manual Chapter 5 (Column Maps) and review the section titled "Compatibility Rules for Column Maps"
Hope that helps.