i have prob with effectve date and end date

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vsandu
Participant
Posts: 13
Joined: Mon Aug 09, 2010 3:50 am

i have prob with effectve date and end date

Post by vsandu »

hi All
my data is like

Code: Select all

	prod_id , prod_start date , prod_end date ,Amt_d
	000440250509	01/22/2005	12/31/9999	19.98
	000440250509	01/29/2005	12/31/9999	19.98
	000440250509	02/05/2005	12/31/9999	19.98
	000440250509	02/12/2005	12/31/9999	19.98
	000440250509	02/19/2005	12/31/9999	19.98
	000440250509	02/26/2005	12/31/9999	19.98
	000440250509	03/05/2005	12/31/9999	19.98
	000440250509	03/12/2005	12/31/9999	19.98
	000440250509	03/19/2005	12/31/9999	19.98
	000440250509	03/26/2005	12/31/9999	19.98
	000440250509	04/02/2005	12/31/9999	19.98
	000440250509	04/09/2005	12/31/9999	19.98
	000440250509	04/16/2005	12/31/9999	19.98
	000440250509	04/23/2005	12/31/9999	19.98
	000440250509	04/30/2005	12/31/9999	19.98
	000440250509	05/07/2005	12/31/9999	19.98
	000440250509	05/14/2005	12/31/9999	19.98
	000440250509	05/21/2005	12/31/9999	19.98
	000440250509	05/28/2005	12/31/9999	19.98
	000440250509	06/04/2005	12/31/9999	19.98
	000440250509	06/11/2005	12/31/9999	19.98
	000440250509	06/18/2005	12/31/9999	19.98
	000440250509	06/25/2005	12/31/9999	19.98
	000440250509	07/02/2005	12/31/9999	19.98
	000440250509	07/09/2005	12/31/9999	19.98
	000440250509	07/16/2005	12/31/9999	19.98
	000440250509	07/23/2005	12/31/9999	19.98
	000440250509	07/30/2005	12/31/9999	19.98
	000440250509	08/06/2005	12/31/9999	19.98
	000440250509	08/13/2005	12/31/9999	19.98
	000440250509	08/20/2005	12/31/9999	19.98
	000440250509	08/27/2005	12/31/9999	19.98
	000440250509	09/03/2005	12/31/9999	19.98
	000440250509	09/10/2005	12/31/9999	19.98
	000440250509	09/17/2005	12/31/9999	19.98
	000440250509	09/24/2005	12/31/9999	19.98
	000440250509	10/01/2005	12/31/9999	19.98
	000440250509	10/08/2005	12/31/9999	19.98
	000440250509	10/15/2005	12/31/9999	19.98
	000440250509	10/22/2005	12/31/9999	19.98
	000440250509	10/29/2005	12/31/9999	19.98
	000440250509	11/05/2005	12/31/9999	19.98
	000440250509	11/12/2005	12/31/9999	19.98
	000440250509	11/19/2005	12/31/9999	19.98
	000440250509	11/26/2005	12/31/9999	19.98
	000440250509	12/03/2005	12/31/9999	19.98
	000440250509	12/10/2005	12/31/9999	19.98
	000440250509	12/17/2005	12/31/9999	19.98
	000440250509	12/24/2005	12/31/9999	19.98
	000440250509	12/31/2005	12/31/9999	19.98
	000440250509	01/07/2006	12/31/9999	19.98
	000440250509	01/14/2006	12/31/9999	19.98
	000440250509	01/21/2006	12/31/9999	19.98
	000440250509	01/28/2006	12/31/9999	19.98
	000440250509	02/04/2006	12/31/9999	19.98
	000440250509	02/11/2006	12/31/9999	19.98
	000440250509	02/18/2006	12/31/9999	19.98
	000440250509	02/25/2006	12/31/9999	19.98
	000440250509	03/04/2006	12/31/9999	19.98
	000440250509	03/11/2006	12/31/9999	19.98
	000440250509	03/18/2006	12/31/9999	19.98
	000440250509	03/25/2006	12/31/9999	19.98
	000440250509	04/01/2006	12/31/9999	19.98
	000440250509	04/08/2006	12/31/9999	19.98
	000440250509	04/15/2006	12/31/9999	19.98
	000440250509	04/22/2006	12/31/9999	19.98
	000440250509	04/29/2006	12/31/9999	19.98
	000440250509	05/06/2006	12/31/9999	19.98
	000440250509	05/13/2006	12/31/9999	19.98
	000440250509	05/20/2006	12/31/9999	19.98
	000440250509	05/27/2006	12/31/9999	19.98
	000440250509	06/03/2006	12/31/9999	19.98
	000440250509	06/10/2006	12/31/9999	19.98
	000440250509	06/17/2006	12/31/9999	19.98
	000440250509	06/24/2006	12/31/9999	19.98
	000440250509	07/01/2006	12/31/9999	19.98
	000440250509	07/08/2006	12/31/9999	19.98
	000440250509	07/15/2006	12/31/9999	19.98
	000440250509	07/22/2006	12/31/9999	19.98
	000440250509	07/29/2006	12/31/9999	19.98
	000440250509	08/05/2006	12/31/9999	19.98
	000440250509	08/12/2006	12/31/9999	19.98
	000440250509	08/19/2006	12/31/9999	19.98
	000440250509	08/26/2006	12/31/9999	19.98
	000440250509	09/02/2006	12/31/9999	19.98
	000440250509	09/09/2006	12/31/9999	19.98
	000440250509	09/16/2006	12/31/9999	19.98
	000440250509	09/23/2006	12/31/9999	19.98
	000440250509	09/30/2006	12/31/9999	19.98
	000440250509	10/07/2006	12/31/9999	19.98
	000440250509	10/14/2006	12/31/9999	19.98
	000440250509	10/21/2006	12/31/9999	19.98
	000440250509	10/28/2006	12/31/9999	19.98
	000440250509	11/04/2006	12/31/9999	19.98
	000440250509	11/11/2006	12/31/9999	19.98
	000440250509	11/18/2006	12/31/9999	19.98
	000440250509	11/25/2006	12/31/9999	19.98
	000440250509	12/02/2006	12/31/9999	19.98
	000440250509	12/09/2006	12/31/9999	19.98
	000440250509	12/16/2006	12/31/9999	19.98
	000440250509	12/23/2006	12/31/9999	19.98
	000440250509	12/30/2006	12/31/9999	19.98
	000440250509	01/06/2007	12/31/9999	19.98
	000440250509	01/13/2007	12/31/9999	19.98
	000440250509	01/20/2007	12/31/9999	19.98
	000440250509	01/27/2007	12/31/9999	14.97
	000440250509	02/03/2007	12/31/9999	14.97
	000440250509	02/10/2007	12/31/9999	14.97
	000440250509	02/17/2007	12/31/9999	14.97
	000440250509	02/24/2007	12/31/9999	14.97
	000440250509	03/03/2007	12/31/9999	14.97
	000440250509	03/10/2007	12/31/9999	14.97
	000440250509	03/17/2007	12/31/9999	14.97
	000440250509	03/24/2007	12/31/9999	14.97
	000440250509	03/31/2007	12/31/9999	14.97
	000440250509	04/07/2007	12/31/9999	14.97
	000440250509	04/14/2007	12/31/9999	14.97
	000440250509	04/21/2007	12/31/9999	14.97
	000440250509	04/28/2007	12/31/9999	14.97
	000440250509	05/05/2007	12/31/9999	14.97
	000440250509	05/12/2007	12/31/9999	14.97
in above data eff_enddate is temporarly i populated commen date
i need to find effctive end date based on amt_d changed

if amt_d value is changed that date is end date and new mat_d start date

please sussest me solution for this prob
Venkat Sandu
vsandu.cg@gmail.com
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Make another post indicating what version of software and operating system, then wait for the moderator to move this question to an appropriate forum.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Moved
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:
Contact jwiles

Post by jwiles »

What does the data in Amt_d represent? Be as precise as possible, please.

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”