Hi All,
i have a field named - "ITEM_SEQ_R" Num(5,0),the values for the field in the Sql database are 622,355.
when i use the above field and generate a text file then i get output as
' 00622.',But i want the output as '000622.'
when i concatenate a '0' then i get '0 00622.',So my question is How can i get this value in Datastage -- '000622.' instead of ' 00622.'
Dealing with Numeric value in Datastage.
Moderators: chulett, rschirm, roy
Define your field as 6 digits in length instead of 5.
The space you're seeing is reserved for the sign in a decimal (Number field) which has been converted to character...you can always Trim() it before concatenating (unless it's '-' then you'll need to use left(), right() and/or substrings).
Regards,
The space you're seeing is reserved for the sign in a decimal (Number field) which has been converted to character...you can always Trim() it before concatenating (unless it's '-' then you'll need to use left(), right() and/or substrings).
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.