Hello !
I have a question.
a.JO_NUM = "RI"
i have this in sql server
a.JO_NUM+replicate(space(1),6-LEN(a.JO_NUM))
result : "RI "
with datastage i try this:
Fmt(Extraction.JO_Num, "6-Len(Extraction.JO_Num)'Space(1)'U")
But the result is not good.
result "RI"
if you have a idea ..... thanks.
Nick
completing a result
Moderators: chulett, rschirm, roy
Try
Code: Select all
Fmt(Extraction.JO_Num,6-Len(Extraction.JO_Num) : ' L')
Success consists of getting up just one more time than you fall.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Seems too complex to me. I'd use:
Code: Select all
Fmt(a.JO_NUM, "L#6")
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.