Search found 21 matches
- Wed Jun 02, 2010 2:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: subtract a day from DSJobStartTimestamp
- Replies: 3
- Views: 3861
Use Julianday Function
make that column as Julianday from date and minus 1 and again revert as date from julianday, Please correct if i am wrong
- Wed Jun 02, 2010 10:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Function to check duplicate values in record
- Replies: 2
- Views: 1472
Function to check duplicate values in record
Hi,
I am in need a function to check duplicate values on record in transformer, is there any function available in parallel. please help in thism thanks in advance.
I am in need a function to check duplicate values on record in transformer, is there any function available in parallel. please help in thism thanks in advance.
- Tue Jun 01, 2010 3:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert to Global Time Zone using the Time Zone conversion
- Replies: 3
- Views: 13138
Convert to Global Time Zone using the Time Zone conversion
Hi,
I have a Situation as "Convert to Global Time Zone using the Time Zone conversion " for given timestamp field , Please help in this , thanks in ADVANCE
I have a Situation as "Convert to Global Time Zone using the Time Zone conversion " for given timestamp field , Please help in this , thanks in ADVANCE
- Thu May 27, 2010 12:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Functions to get total number of records
- Replies: 10
- Views: 2872
Using Basic Trancformer In Px
Isn't that what I said? You just used way more words, Andy. :wink: (and nice sig, perhaps I should switch from silly quotes to titles, awards and my phone number, too) LOL Thanks for all your suggestions, but when i am using Basic Transformer in Parallel Job the performance is very slow , more over...
- Wed May 26, 2010 7:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Functions to get total number of records
- Replies: 10
- Views: 2872
I need in Parallel only
Please use meaningful subject lines, it helps searchers of the site. Your Subject and Additional Info should have been swapped, that or just skipped the whole "Hi" part as we're quite the friendly bunch and are all about the solutions. :wink: All that can be done "after job" fro...
- Wed May 26, 2010 4:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Functions to get total number of records
- Replies: 10
- Views: 2872
Functions to get total number of records
Hi Gurus , I have a situation like want to get how much records inserted in the target, and also status of the job in a table during runtime, is there any functions or logic in dastage parallel, please help in this regard thanks in advance. [* Note - Title changed to be relevant to topic - Andy *]