Conversion from numeric to string in a job
Moderators: chulett, rschirm, roy
Conversion from numeric to string in a job
Hi,
I need to convert NUMERIC(10) datatype to NVARCHAR(10) in Parallel Job from desinger. when i change the type and execute it throws error.
is there a way to do it.
Thanks,
Vindy
I need to convert NUMERIC(10) datatype to NVARCHAR(10) in Parallel Job from desinger. when i change the type and execute it throws error.
is there a way to do it.
Thanks,
Vindy
I changed the datatype in designer from numeric to nvarchar and i try to run the job i get the following:
Error when checking operator: When binding output schema variable "resRec": When binding output interface field "NOMINATION_KEY" to field "NOMINATION_KEY": Implicit conversion from source type "decimal[10,0]" to result type "ustring[max=10]": Not enough room in ustring for decimal[10,0].
What should i do to convert type in desinger.
Thanks,
Vindy
Error when checking operator: When binding output schema variable "resRec": When binding output interface field "NOMINATION_KEY" to field "NOMINATION_KEY": Implicit conversion from source type "decimal[10,0]" to result type "ustring[max=10]": Not enough room in ustring for decimal[10,0].
What should i do to convert type in desinger.
Thanks,
Vindy
I changed the datatype in designer from numeric to nvarchar and i try to run the job i get the following:
Error when checking operator: When binding output schema variable "resRec": When binding output interface field "NOMINATION_KEY" to field "NOMINATION_KEY": Implicit conversion from source type "decimal[10,0]" to result type "ustring[max=10]": Not enough room in ustring for decimal[10,0].
What should i do to convert type in desinger.
Thanks,
Vindy
Error when checking operator: When binding output schema variable "resRec": When binding output interface field "NOMINATION_KEY" to field "NOMINATION_KEY": Implicit conversion from source type "decimal[10,0]" to result type "ustring[max=10]": Not enough room in ustring for decimal[10,0].
What should i do to convert type in desinger.
Thanks,
Vindy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That is not the correct way to do this, even though it is allowed. There is a modify stage which is designed to do conversions such as this.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
Hi I guess In the transformer,
left pane bottom put the datatype of the source
and in the right pane bottom put the datatype of the target
Now in the drag and drop canvas
right click on the derivation part,
u can see the type conversion functions
and which ever conversion u want u can go ahead
this will eliminate the warnings tooo
thanks
suresh
left pane bottom put the datatype of the source
and in the right pane bottom put the datatype of the target
Now in the drag and drop canvas
right click on the derivation part,
u can see the type conversion functions
and which ever conversion u want u can go ahead
this will eliminate the warnings tooo
thanks
suresh
bgs_vb wrote:yes you are correct. Is that the correct way to do, if not how could i go ahead in doing the change.
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
u can do this in the following way
Hi I guess In the transformer,
left pane bottom put the datatype of the source
and in the right pane bottom put the datatype of the target
Now in the drag and drop canvas
right click on the derivation part,
u can see the type conversion functions
and which ever conversion u want u can go ahead
this will eliminate the warnings tooo
thanks
suresh
left pane bottom put the datatype of the source
and in the right pane bottom put the datatype of the target
Now in the drag and drop canvas
right click on the derivation part,
u can see the type conversion functions
and which ever conversion u want u can go ahead
this will eliminate the warnings tooo
thanks
suresh
bgs_vb wrote:yes you are correct. Is that the correct way to do, if not how could i go ahead in doing the change.
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
u can do this in the following way
Hi I guess In the transformer,
left pane bottom put the datatype of the source
and in the right pane bottom put the datatype of the target
Now in the drag and drop canvas
right click on the derivation part,
u can see the type conversion functions
and which ever conversion u want u can go ahead
this will eliminate the warnings tooo
thanks
suresh
left pane bottom put the datatype of the source
and in the right pane bottom put the datatype of the target
Now in the drag and drop canvas
right click on the derivation part,
u can see the type conversion functions
and which ever conversion u want u can go ahead
this will eliminate the warnings tooo
thanks
suresh
bgs_vb wrote:yes you are correct. Is that the correct way to do, if not how could i go ahead in doing the change.
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
Re: Conversion from numeric to string in a job
Hi I guess In the transformer,
left pane bottom put the datatype of the source
and in the right pane bottom put the datatype of the target
Now in the drag and drop canvas
right click on the derivation part,
u can see the type conversion functions
and which ever conversion u want u can go ahead
this will eliminate the warnings tooo
thanks
suresh
left pane bottom put the datatype of the source
and in the right pane bottom put the datatype of the target
Now in the drag and drop canvas
right click on the derivation part,
u can see the type conversion functions
and which ever conversion u want u can go ahead
this will eliminate the warnings tooo
thanks
suresh
bgs_vb wrote:Hi,
I need to convert NUMERIC(10) datatype to NVARCHAR(10) in Parallel Job from desinger. when i change the type and execute it throws error.
is there a way to do it.
Thanks,
Vindy
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand