Page 1 of 1
What is the equivalent function in parallel for 'Fmt'
Posted: Wed Oct 17, 2007 5:16 am
by vcsasikala
I'm converting a server job to Parellel job.
I don't know how to replace a function Fmt(Column,"11RZ").
How to Suppress leading zeros in parallel job?
Posted: Wed Oct 17, 2007 5:27 am
by ArndW
Although there is no equivalent PX/EE function for the BASIC "FMT" there is usually no need to use one. PX will perform automated input conversions. Do you need to perform a specific output conversion?
Posted: Wed Oct 17, 2007 5:27 am
by Maveric
"How to Suppress leading zeros in parallel job?". What is the data type of your source? If it is varchar then use Trim (Input.col,"0","L"). This would trim the leading zeros only.