Search found 186 matches
- Thu Feb 08, 2007 9:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date format (last day of previous month)
- Replies: 4
- Views: 3351
Date format (last day of previous month)
Iam using DataStage 7.5 PX version, I have date coming as 2007-03-02, 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.
- Sat Feb 03, 2007 6:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: pipe function to be implemented
- Replies: 2
- Views: 1011
pipe function to be implemented
nv_year_month TIME_DT_D.MONTH_INTLGNT_KEY%TYPE SELECT A.PERSON_KEY, A.EFF_DT FROM DBA.EVENT_F A, DBA.TIME_DT_D F, DBA.EVENT_D D WHERE A.TIME_DT_INTLGNT_KEY = F.TIME_DT_INTLGNT_KEY AND F.CAL_DAY_DT <= SYSDATE AND F.MONTH_INTLGNT_KEY <= ' || nv_year_month || ' I have above SQL query in package in Orac...
- Wed Nov 29, 2006 6:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Implementing Greatest,Least Function in Datastage
- Replies: 5
- Views: 2976
- Wed Nov 29, 2006 6:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Implementing Greatest,Least Function in Datastage
- Replies: 5
- Views: 2976
- Wed Nov 29, 2006 5:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Implementing Greatest,Least Function in Datastage
- Replies: 5
- Views: 2976
Implementing Greatest,Least Function in Datastage
Hi,
How can findout among 5 date columns Greatest Date,Least Date in DataSatge7.5 PX
How can findout among 5 date columns Greatest Date,Least Date in DataSatge7.5 PX
- Wed Oct 04, 2006 8:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LooKUp Stage Condition
- Replies: 3
- Views: 2489
LooKUp Stage Condition
Hi, In PX7.5 Lookup Stage having constraints Condition Not Met,Lookup Failure. My Source columns as ecode,scode,date... Lookup columns as ecode,scode,datein,dateout... Baded on ecode,scode i am specifying lookup condition,After that as for my requirement specifying condition as (date>=datein and dat...