Search found 21 matches

by rameshkm
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
by rameshkm
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.
by rameshkm
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
by rameshkm
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...
by rameshkm
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...
by rameshkm
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 *]