error
Moderators: chulett, rschirm, roy
error
Hi All,
i am getting this following error message
DataStage Job 542 Phantom 27961
Program "JOB.321231104.DT.1405157533.TRANS1": Line 137, Nonnumeric data when numeric required. Zero used.
DataStage Phantom Finished
can some one let me know how to resolve this.
Thanks in advance
i am getting this following error message
DataStage Job 542 Phantom 27961
Program "JOB.321231104.DT.1405157533.TRANS1": Line 137, Nonnumeric data when numeric required. Zero used.
DataStage Phantom Finished
can some one let me know how to resolve this.
Thanks in advance
error
Hi DSGuru,
source-->transformer1--->sort--->transformer2-->hashfile
i am doing a sort on version.
Thanks in advance
source-->transformer1--->sort--->transformer2-->hashfile
i am doing a sort on version.
Thanks in advance
DSguru2B wrote:Ok. This will get us no where. Did you pay attention to what Ken had asked?
Also, i am still waiting for your job design and what exactly are you doing in it.
The sort stage expects to do a numeric sort if a column has a data type of numeric and is one of the sort columns. Tell me, what number do you want A1 changed into?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Yes. The sort stage is expecting a numberic value and bumps on 'A1' which we both know is not numeric. Now either you need to fix your incoming data or have to go for a character sort, which might be different from what you are actually looking for , so, as Ken is asking, specify the value of A1 and handle that.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
Re: error
[quote="adams06"]
how can we convert this nonnumeric data(A1) into numeric.
/quote]
I did not get what numeric value you want for (A1)...
But you can use NUM() to check whether come value is numeric or alphabatic
for numeric it will return 1 and for alphbatic 0..
Give the condition like if NUM(Value)=0 then @NULL else value...
Thanks,
Anupam
how can we convert this nonnumeric data(A1) into numeric.
/quote]
I did not get what numeric value you want for (A1)...
But you can use NUM() to check whether come value is numeric or alphabatic
for numeric it will return 1 and for alphbatic 0..
Give the condition like if NUM(Value)=0 then @NULL else value...
Thanks,
Anupam
Re: error
Why is it complaining for Numeric if it is defined as Varchar?adams06 wrote:The column is defined as varchar only.
DSguru2B wrote:Dont change it. Specify that column as varchar. Or you will lose that data.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'