DSXchange

Hi All,

I am stuck in requirement where I need to pass DATE_FROM and DATE_TO in sequence job activities where DATE_FROM is first day of previous moth and DATE_TO is last day of previous month if I am running my sequence in current month.

Can anyone help me with the date derivation logic.


Regards
Prasoon

If you want to use User Variable stage and DataStage BASIC, then I would guess you have to create a routine and call it.

Or, you could do something like what is mentioned by ArndW in this topic.

I'd also recommend User Variables.

Examine the Transforms in your Repository, particularly MONTH.FIRST and MONTH.LAST to get ideas about how to calculate these dates.

Use your database and write the output to a file.

select trunc(sysdate,'MONTH')-1 as lastdayofpreviousmonth,trunc(trunc(sysdate,'MONTH')-1,'MONTH') as firstdayofpreviousmonth from dual

Note that vamsi_4a6's syntax is specific for Oracle.