FMT function logic in PX

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Raghava
Participant
Posts: 13
Joined: Tue Jan 24, 2006 1:20 am
Contact:

FMT function logic in PX

Post by Raghava »

Hi All,

fmt(ABS(Quantity)*New_Price_Per_Share,"T0")

How to implement the above logic in PX transformer?

Thanks In Advance!!!!

Regards,

Rag
suresh_dsx
Participant
Posts: 160
Joined: Tue May 02, 2006 7:49 am

Migration

Post by suresh_dsx »

Please see the below.
I also have same requirement.
How can i use the fmt function in the parallel jobs.
Please give me some suggestions.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Code: Select all

INT(ABS(Quantity)*New_Price_Per_Share) 
should offer the same functionality.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Create a parallel routine that mimics some or all of the functionality of the Fmt() function - at least that subset that you require.

And stop thinking like a server job developer! Parallel jobs are a totally different product (formerly Orchestrate).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply