Hi,
Having an error compiling a transform stage susing the following:
CompactWhiteSpace(Trim(TPRTNLOC_01.STREET_NUMBER,"0","L"):" ": TPRTNLOC_01.STREET_NUMBER_SUFF:" ": TPRTNLOC_01.SUITE_NUMBER:" ": TPRTNLOC_01.STREET_NAME:" ": TPRTNLOC_01.STREET_DIRECTION:" ": TPRTNLOC_01.RURAL_ROUTE_NUMBER)
Problem is caused by the TRIM function. Without it it, the job compiles and run fine. Am I using the right format for the TRIM character and option? I have try a couple of combination and the one above seems the only one accepted by DS.
Thanks.
Compiling error on Transform stage using TRIM with L option
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Fri May 21, 2004 4:22 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try putting the Trim(TPRTNLOC_01.STREET_NUMBER,"0","L") into a stage variable, and replacing that part of the expression with a reference to the stage variable.
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.