error

adams06 · Post by **adams06** » Tue Jun 20, 2006 12:26 pm

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

kcbland · Post by **kcbland** » Tue Jun 20, 2006 12:50 pm

You have a math expression somewhere that is not allowing for character data.

DSguru2B · Post by **DSguru2B** » Tue Jun 20, 2006 12:51 pm

Need to know your job design. What exactly are you doing?

kris007 · Post by **kris007** » Tue Jun 20, 2006 12:51 pm

The error says it all. You are trying to enter non-numeric data where it is expecting numeric data. Look into your Transformer stage and the derivations you are using in it.

adams06 · Post by **adams06** » Tue Jun 20, 2006 12:56 pm

I have one record i.e A1 which is creating problem.

version

A1
00
01
07

how can we convert this nonnumeric data(A1) into numeric.

thanks in advance.

DSguru2B wrote:Need to know your job design. What exactly are you doing?

DSguru2B · Post by **DSguru2B** » Tue Jun 20, 2006 12:57 pm

Dont change it. Specify that column as varchar. Or you will lose that data.

adams06 · Post by **adams06** » Tue Jun 20, 2006 1:12 pm

The column is defined as varchar only.

DSguru2B wrote:Dont change it. Specify that column as varchar. Or you will lose that data.

kris007 · Post by **kris007** » Tue Jun 20, 2006 1:19 pm

Is the datatype set to Varchar in Target? Are you sure?

DSguru2B · Post by **DSguru2B** » Tue Jun 20, 2006 1:21 pm

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.

adams06 · Post by **adams06** » Tue Jun 20, 2006 1:33 pm

Hi DSGuru,

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.

kcbland · Post by **kcbland** » Tue Jun 20, 2006 1:36 pm

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?

DSguru2B · Post by **DSguru2B** » Tue Jun 20, 2006 1:39 pm

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.

sb_akarmarkar · Post by **sb_akarmarkar** » Wed Jun 21, 2006 6:14 am

[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

kumar_s · Post by **kumar_s** » Wed Jun 21, 2006 8:09 am

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.

Why is it complaining for Numeric if it is defined as Varchar?

DSguru2B · Post by **DSguru2B** » Wed Jun 21, 2006 9:15 am

I dont think it is throughout, maybe at the source, but it has to be defined varchar at both the input and output of the sort stage.

DSXchange

error

error

error

error

error

Re: error

Re: error