Search found 37 matches
- Sat Jan 19, 2013 12:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Difference between 2 dates
- Replies: 2
- Views: 2041
- Sat Jan 19, 2013 8:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Difference between 2 dates
- Replies: 2
- Views: 2041
Difference between 2 dates
Hi,
I need to get number of days between two dates in transformer. One of them is having format: 12/25/2009 and other one is like 1/21/2000 12:00:00.000000 AM.
Basically I need to implement TRUNC(DATE) functionality of Oracle.
I need to get number of days between two dates in transformer. One of them is having format: 12/25/2009 and other one is like 1/21/2000 12:00:00.000000 AM.
Basically I need to implement TRUNC(DATE) functionality of Oracle.
- Tue Jan 11, 2011 1:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Strings with Quotes in Oracle Connector-Stage
- Replies: 6
- Views: 7786
- Thu Jan 06, 2011 11:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MONTH & YEAR FROM DATE
- Replies: 10
- Views: 5695
Ray,ray.wurlod wrote:...Code: Select all
Right("00":MonthFromDate(InLink.TheDate) : "-" : Right(YearFromDate(InLink.TheDate),2)
Should we use:
Right("00":MonthFromDate(InLink.TheDate),2) : "-" : Right(YearFromDate(InLink.TheDate),2)
??? as the requirement is MM-YY?
- Wed Jan 05, 2011 6:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage paralle job hanging
- Replies: 4
- Views: 3219
- Wed Jan 05, 2011 2:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Internal Error Partitions...
- Replies: 7
- Views: 6184
- Sun Nov 28, 2010 2:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to reference input columns listed in schema file
- Replies: 7
- Views: 4315
- Sun Nov 28, 2010 2:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calling Unix script in parallel from multiple jobs
- Replies: 4
- Views: 3502
- Fri Oct 15, 2010 12:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: self join
- Replies: 4
- Views: 2946
- Fri Oct 15, 2010 11:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: self join
- Replies: 4
- Views: 2946
- Fri Oct 15, 2010 11:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: join & lookup
- Replies: 9
- Views: 3643
- Fri Oct 15, 2010 6:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: self join
- Replies: 4
- Views: 2946
self join
Hi, Suppose I have data which has 3 columns - emp_id, emp_name and mgr_id where mgr_i is emp's manager's id. I need to know how many employees are there who does not manage anyone. One approach might be self join but is anybody having any idea how it can be implemented in datastage without using sel...
- Fri Oct 15, 2010 6:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: join & lookup
- Replies: 9
- Views: 3643
- Fri Oct 15, 2010 5:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: deleting datasets
- Replies: 2
- Views: 1927
- Fri Oct 15, 2010 5:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: deleting datasets
- Replies: 2
- Views: 1927
deleting datasets
Hi All,
If I need to delete a dataset (data file as well as header file what should be given in orchadmin command?
orchadmin rm dataset_name.ds?
would this delete both of them?
If I need to delete a dataset (data file as well as header file what should be given in orchadmin command?
orchadmin rm dataset_name.ds?
would this delete both of them?