Maximum of Effective Date
Posted: Tue Nov 30, 2004 7:48 pm
Hi,
I am new to Datastage. I need to retreive Maximum(EFFDT) value based on a condition for my update statement. I have read the earlier messages about using an aggregator stage or input MAX(EFFDT) in the selection tab of input stage. Is there any other way to do it without using either the aggregator stage or the user defined sql. Please let me know.
Thanks in advance,
Deepa
I am new to Datastage. I need to retreive Maximum(EFFDT) value based on a condition for my update statement. I have read the earlier messages about using an aggregator stage or input MAX(EFFDT) in the selection tab of input stage. Is there any other way to do it without using either the aggregator stage or the user defined sql. Please let me know.
Thanks in advance,
Deepa