decimal_from_string dosent work ?
Moderators: chulett, rschirm, roy
decimal_from_string dosent work ?
I am trying to change a CHAR to a DECIMAL using modify stage. My source is a DATA SET and the column name is "OFFER_ID". I am using OFFER_ID:decimal[8,0]= decimal_from_string(OFFER_ID).
This does not work. Is there another way to do this?.
I am using a basic transformer in PX , so can I change the datatype in the transformer directly?.... will it work like in the server edition?
This does not work. Is there another way to do this?.
I am using a basic transformer in PX , so can I change the datatype in the transformer directly?.... will it work like in the server edition?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
decimal_from_string works fine for me, provided that the source column contains eight or fewer numeric characters and nothing else. Perhaps you have a problem with your data?
"It doesn't work" is singularly helpful as diagnostic information. (That's why vets charge more than doctors.)
"It doesn't work" is singularly helpful as diagnostic information. (That's why vets charge more than doctors.)
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.
"It doesn't work" is singularly helpful as diagnostic information. (That's why vets charge more than doctors.)[/quote]
This is the error:
APT_CombinedOperatorController,0: Un-handled conversion error on field "PROMO_ID " from source type "string[8]" to dest type "decimal[8,0]": source value=""6343"": Result is non-nullable and there is no handle_null to specify a default value
Un-handled conversion error on field "OFFER_ID " from source type "string[8]" to dest type "decimal[8,0]": source value=""8894"": Result is non-nullable and there is no handle_null to specify a default value
I'v tried giving NULLABLE, still gives out this error.
How do I specify the null handling property ?
@ Kumar_S
We use 7.0 now, and for some reasons it has to be upgraded to get the parallel transformer, I am not quite sure![Confused :?](./images/smilies/icon_confused.gif)
![Embarassed :oops:](./images/smilies/icon_redface.gif)
![Laughing :lol:](./images/smilies/icon_lol.gif)
This is the error:
APT_CombinedOperatorController,0: Un-handled conversion error on field "PROMO_ID " from source type "string[8]" to dest type "decimal[8,0]": source value=""6343"": Result is non-nullable and there is no handle_null to specify a default value
Un-handled conversion error on field "OFFER_ID " from source type "string[8]" to dest type "decimal[8,0]": source value=""8894"": Result is non-nullable and there is no handle_null to specify a default value
I'v tried giving NULLABLE, still gives out this error.
How do I specify the null handling property ?
@ Kumar_S
We use 7.0 now, and for some reasons it has to be upgraded to get the parallel transformer, I am not quite sure
![Confused :?](./images/smilies/icon_confused.gif)
What is the job desing? May be the operator combination might screwed up your function. Try with Combinable operator to false.
If you have parallel version, I dont think transformer is a plugin to upgrade. you should be having the stage, may be you may need to customize your pallet to get the stage in. You can accomplish this fucntionality in the transformer it self, and hence you can eliminate the Modify if its an addition stage just for this purpose.
If you have parallel version, I dont think transformer is a plugin to upgrade. you should be having the stage, may be you may need to customize your pallet to get the stage in. You can accomplish this fucntionality in the transformer it self, and hence you can eliminate the Modify if its an addition stage just for this purpose.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
@ Kumar
I have the parallel transformer in the palette but we dont have the compiler for it or sumthin. (not quite sure abt the reason )
Modify stage work for me now, turns out the data I have has retained some quotes chars from the previous server job where I am getting the data from.
Thanx for yr help guys.![Smile :)](./images/smilies/icon_smile.gif)
I have the parallel transformer in the palette but we dont have the compiler for it or sumthin. (not quite sure abt the reason )
Modify stage work for me now, turns out the data I have has retained some quotes chars from the previous server job where I am getting the data from.
Thanx for yr help guys.
![Smile :)](./images/smilies/icon_smile.gif)