Search found 59 matches
- Fri Oct 12, 2012 1:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting Aug 2 1958 12:00AM to 1958-08-02 12:00:00
- Replies: 3
- Views: 2737
- Fri Oct 12, 2012 12:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting Aug 2 1958 12:00AM to 1958-08-02 12:00:00
- Replies: 3
- Views: 2737
Converting Aug 2 1958 12:00AM to 1958-08-02 12:00:00
HI,
From source the values are coming like below
May 30 1967 12:00AM
Aug 2 1958 12:00AM
i need to convert in to timestamp like 1958-08-02 12:00:00
if any one has any idea plz let me know ,
Thanks in Advance
From source the values are coming like below
May 30 1967 12:00AM
Aug 2 1958 12:00AM
i need to convert in to timestamp like 1958-08-02 12:00:00
if any one has any idea plz let me know ,
Thanks in Advance
- Fri Oct 28, 2011 12:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Strip double quotes at end of the record
- Replies: 4
- Views: 2635
- Wed Jul 13, 2011 12:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 API stage error
- Replies: 3
- Views: 3091
- Fri Feb 25, 2011 12:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warnings due to date_from_string,julian_day_from_date fns
- Replies: 6
- Views: 7230
Try using this to make sure your data is correct. and reject the row that has invalid date conversions IsValidDate Returns whether the given value is valid for the type date. v Input: testdate (date) v Output: result (int8) v Examples. If the column mylink.mydate contains the date 2011-09-13, then ...
- Fri Feb 25, 2011 12:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warnings due to date_from_string,julian_day_from_date fns
- Replies: 6
- Views: 7230
Try using this to make sure your data is correct. and reject the row that has invalid date conversions IsValidDate Returns whether the given value is valid for the type date. v Input: testdate (date) v Output: result (int8) v Examples. If the column mylink.mydate contains the date 2011-09-13, then ...
- Fri Feb 25, 2011 12:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warnings due to date_from_string,julian_day_from_date fns
- Replies: 6
- Views: 7230
Try using this to make sure your data is correct. and reject the row that has invalid date conversions IsValidDate Returns whether the given value is valid for the type date. v Input: testdate (date) v Output: result (int8) v Examples. If the column mylink.mydate contains the date 2011-09-13, then ...
- Fri Oct 29, 2010 12:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to implement Reject logic
- Replies: 13
- Views: 8184
Re: how to implement Reject logic
Hi,
Afer sequential file take transformer and do the count based on '|'
any way you will be knowing the max limit so that you can put constraint
in transformer saying that count less than that should be passed else rejected.
Afer sequential file take transformer and do the count based on '|'
any way you will be knowing the max limit so that you can put constraint
in transformer saying that count less than that should be passed else rejected.
- Thu Oct 28, 2010 12:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Footer record for each group by value
- Replies: 7
- Views: 6377
You could have multiple ordered sources with the following format: Key1 Key2 RowContents Src 1 (header): -1 0 Header----------------- The -1 is just to make sure the header comes first. You could have another key that comes first in the order that does nothing more than order the sources (eg: 0 for...
- Wed Oct 27, 2010 11:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Footer record for each group by value
- Replies: 7
- Views: 6377
Declare your output format as a single VarChar column. In your job, detect the value group changes using either stage variables in a transform or within a sort stage. When your job detects a group change it outputs an additional record with the footer values as indicated in your example. Hi, Thanks...
- Wed Oct 27, 2010 4:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Footer record for each group by value
- Replies: 7
- Views: 6377
Footer record for each group by value
Hi,
I need to implement a scenario and pass it to a file with one header and multiple footer records like
Input:
emp_id
100
100
200
200
200
300
Output:
Header--------------
100
2(count)
200
3(count)
300
1(count)
Your suggestions is appreciated!
Thanks in Advance
I need to implement a scenario and pass it to a file with one header and multiple footer records like
Input:
emp_id
100
100
200
200
200
300
Output:
Header--------------
100
2(count)
200
3(count)
300
1(count)
Your suggestions is appreciated!
Thanks in Advance
- Wed Oct 20, 2010 1:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Adding rows to a single column
- Replies: 8
- Views: 5427
- Wed Oct 20, 2010 12:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Adding rows to a single column
- Replies: 8
- Views: 5427
Use Len() functions to compare lengths. ... Hi, sorry to ask again, i can use Len function but if we have data like key data length 1 ------ 5 1 --------- 7 1 ----------- 8 2 ---------- 6 2 ------------ 7 2 -------------- 8 and my output should be like key data length 1 ------------------ 8 2 -----...
- Wed Oct 20, 2010 12:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Adding rows to a single column
- Replies: 8
- Views: 5427
Use stage variables PrevKey = CurrKey CurrKey = Key CurrData = If PrevKey = CurrKey then PrevData : Data else Data PrevData = CurrData Use Remove Duplicates to retain the row which has longest Data. Also you should run this job in 1 node. HI, I have one doubt like we can remove duplilcates based on...
- Wed Sep 29, 2010 1:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date to gregorian Format
- Replies: 2
- Views: 9838
Re: Date to gregorian Format
Hi,ravireddy25 wrote:HI,
I have to convert Date format to Gregorian format, can any one suggest me how to do this, i searched but i didnt get the answers
Any suggestion is appreciated,
Thanks
Ravi
I want the calender date to gregorian date
Ex:2005-08-15 to 38578
Thanks in Advance