Hi there,
I want to create a parallel shared container that will convert any invalid characters that are in the data to spaces or empty strings. So, in my container job I have a tranformer to convert the fields passing through using the convert function. If I have runtime column propegation on, how would I convert the fields using the convert option? or can I not do it that way?
I read through the documentation but it did not say too much about this.
Thanks for any help.
Creating a shared container
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You must specify any field on which you want to perform any kind of operation (such as Trim() in your case). Therefore RCP is not going to help. Nor is a shared container unless metadata are identical. Investigate propagating derivation expression ("derivation substitution") within the Transformer stage.
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.
OK I saw that information in the documentation. I guess what I am trying to do is to create a library of functions that I could use in multiple jobs. So there would be no questions about what to do in certain cases. For example always convert char(0) to empty string. I guess there is no way to do something like this exept to write a c routine. Is this correct?
Thanks for the help.
Thanks for the help.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: