Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
prasanna2100
- Participant
- Posts: 36
- Joined: Mon Mar 27, 2006 12:23 am
- Location: Chennai
Post
by prasanna2100 »
hi all,
While iam trying to get a Varchar data and trying to assign in to a Decimal type column.
getting an error
Unable to set output decimal field value from argument string '' in function setOutputFieldAsDecimal() for field '28' in output dataset '0'.
suggestions please
-
kumar_s
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 5245
- Joined: Thu Jun 16, 2005 11:00 pm
Post
by kumar_s »
Are you tryring in Transformer stage? What function, you are using in?
What is the input / Output Data length and what is assigned in Datastage?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
"" is not valid as a Decimal data type. You are supplying "" and asking for it to be treated as Decimal. This is neither permitted nor possible.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
ramesh_inform
- Participant
- Posts: 57
- Joined: Mon Dec 03, 2007 12:43 am
- Location: hyderabad
Post
by ramesh_inform »
StringToDecimal(%string%,[%rtype%])
try this in transfromer
hope it works
ramesh.n.
-
ramesh_inform
- Participant
- Posts: 57
- Joined: Mon Dec 03, 2007 12:43 am
- Location: hyderabad
Post
by ramesh_inform »
StringToDecimal(%string%,[%rtype%])
try this in transfromer
hope it works
ramesh.n.
-
ramesh_inform
- Participant
- Posts: 57
- Joined: Mon Dec 03, 2007 12:43 am
- Location: hyderabad
Post
by ramesh_inform »
StringToDecimal(%string%,[%rtype%])
try this in transfromer
hope it works
ramesh.n.