How to suppress zero for decimal field in RCP enabled jobs
Moderators: chulett, rschirm, roy
How to suppress zero for decimal field in RCP enabled jobs
Hi All,
I have a RCP enabled jobs for dynamic DB tables. So for every run my table changes. There are some tables which has decimal field and my output is a sequential file. I need to find a way to suppress zero for these fields either at job or sequencer level. Also I am not using schema file.
Can anyone help?
Regards,
Swapna
I have a RCP enabled jobs for dynamic DB tables. So for every run my table changes. There are some tables which has decimal field and my output is a sequential file. I need to find a way to suppress zero for these fields either at job or sequencer level. Also I am not using schema file.
Can anyone help?
Regards,
Swapna
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not if you insist on using RCP throughout.
If you want to apply a transformation to a column, you need to name the column (field).
DataStage adds leading and trailing non-significant zeroes to Decimal numbers to assert/prove the precision and scale values. This behaviour is not (currently) negotiable.
If you want to apply a transformation to a column, you need to name the column (field).
DataStage adds leading and trailing non-significant zeroes to Decimal numbers to assert/prove the precision and scale values. This behaviour is not (currently) negotiable.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
The important part is visible.
You could, perhaps, post-process your text file to remove these zero-valued decimals using awk, sed or some other program.
You could, perhaps, post-process your text file to remove these zero-valued decimals using awk, sed or some other program.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
As I have dynamic tables in the RCP job. So I assume, I will have to read each and every schema file with proper table structure to get decimal field and use sed/awk command to suppress these zeros. And all this activity has to be included in a loop at sequencer.
This seems to be a tough approach
Just by chance , can we have other workaround for this ?
Regards,
Swapna
This seems to be a tough approach
Just by chance , can we have other workaround for this ?
Regards,
Swapna
-
- Participant
- Posts: 10
- Joined: Sun Aug 11, 2013 10:46 pm
- Location: Dalian