DSXchange

Hi,

Thanks for the code, 2nd one works fine, but 1st one still giving **** in the output, (datatype date)

Thanks,

Hi, Thanks for the below derviations. Code: StringToDate(DecimalToString(YearFromDate(CurrentDate())-1):"-12-01", "%dd-%MM-%yyyy") Code: If MonthFromDate(CurrentDate()) = 1 then StringToDate(DecimalToString(YearFromDate(CurrentDate())-1):"-12-01", "%dd-%MMM-%yy&quo...

Hi, I am having a paramter as 2007-01-01, when i run the job i need the following logic to be implemented 1 . select TO_DATE ('12/01/'||TO_CHAR(TO_NUMBER(TO_CHAR(SYSDATE,'YYYY')) -1),'MM/DD/YYYY') from dual; i.,e it should give me 01-DEC-06 as a result. (12/01 is a hardcode values) 2. select TO_DATE...

Hi, I'am having 2 inputs in Aggreagator Stage i. PERSON_K (Integer) ii. SRC_EFF_Y (Date) Sort method has kept to Hash Partitioning set to Auto. Column is grouped by 'Person_K' & calculation is done for SRC_EFF_Y. i.,e Max. value output column I have changed the column name at the o/p of aggregat...

Hi,
How to Implement this in DataStage....
IF B_DT >= PCKG_BEGIN_DT AND B_DT <= FMC_PCKG_END_DT
THEN TYPE := 'N';
ELSIF A_END_DT >= PCKG_BEGIN_DT AND A_END_DT <= FMC_PCKG_END_DT THEN TYPE:= 'R';
ELSE TYPE:='C';


Thanks
Srini

Hi, I have a paramater i.,e Run_Date, i need to pass the value from Row generator to Teradata Stage. I need to delete all the values which ever i give in run time. It should create 1 row and 1 column and send it as input to the TD stage. How to send the run time parameter i.,e Run_date to the row ge...

How to get the year difference between above 2 dates

Thanks

DateFromDaysSince(-1, StringToDate(RUN_DT, "%yyyy%mm") : "%yyyy-%mm-%dd")

got the solution
thanks

Iam using DataStage 7.5 PX version, I have date coming as 200703, i need to convert to 2007-02-28 i.e., last day of the previous month, whenever i run the job, can we do it in a single line i.,e i.,e Transformer.

Srini

Floor(MonthFromDate(DateToString(DSLink2.col1,"%yyyy-%mm-%dd")) -
MonthFromDate(DateToString(DSLink2.col1,"%yyyy-%mm-%dd")))/12

My incoming values are like 2099-12-31 and 2006-12-12.

I have tried the above method, its giving some result like 000000000.

Thanks

Hi,

should i used directly
MonthFromDate() - MonthFromDate() or something else

Thanks
Srini

In Sequencer ...... we designed as three stages jobs....Extr,Cdc,Load.In Job Log it's Showing as only initial four rows like...Startinng,Attached Message,Env,Parallel job initiated,Parallel job default.....After that it's does not show anything in Joblog in Director.

Thanks
Srini

Hi,

I am running a Job from Sequencer Level and also specifying parameters at runtime.But job keep on running,Source side having nearly 15 records only.I aborted Sequencer from UNIX Box.I am unable to findout what are the reasons it's continuously running ......

Thanks
Srini

Hi, 1. Iam using DataStage 7.5 PX version, I have date coming as 200703, i need to convert to 2007-02-28 i.e., last day of the previous month, whenever i run the job, can we do it in a single line i.,e Transformer. I have posted the same question but date was was with different format i.,e 2007-03-0...

Its working, thank you