im reading from sequential file where the amount column starts from position
1-10 and immediately followed by space.
+0000040.00
so im reading as 11 bytes from source and doing left function to take only amount.
when im reading im getting the below message.
Numeric string expected for returned value from function call 'left_substring'. Use default value.
Numeric string expected for returned value from function call 'left_substring'. Use default value.
eliminationg the function call 'left_substring'. Use default
Moderators: chulett, rschirm, roy
eliminationg the function call 'left_substring'. Use default
Regards
LakNar
LakNar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: eliminationg the function call 'left_substring'. Use def
Never having used the transformation language I haven't got the answer, but the reason you are getting the warnings is detailed in the help files:laknar wrote: Numeric string expected for returned value from function call 'left_substring'. Use default value.
Numeric string expected for returned value from function call 'left_substring'. Use default value.
If the input contains a numeric value or string that is not listed in the table, WebSphere DataStage operates as follows:
If a numeric value is unknown, an empty string is returned by default. However, you can set a default string value to be returned by the string lookup table.
If a string has no corresponding value, 0 is returned by default. However, you can set a default numeric value to be returned by the string lookup table.
There was some other detail in the help files about having conversion tables for int/decimal to string... have a read and see if it makes more sense...
But now that it is come to my attention, I may have to look more in to this option...