Modify

kittu.raja · Post by **kittu.raja** » Thu Feb 05, 2009 2:40 pm

Hi,
I am getting a warning 'Sequential_File_2: When checking operator: When binding input interface field "SNo" to field "SNo": Implicit conversion from source type "dfloat" to result type "int32": Possible range/precision limitation."
I used a modify stage then also I am getting the same warning. I searched in the forum but I did not get the solution.
I can do it with transformer AsInteger bu t I want to use Modify stage.
Appreciate your help
Thansk,

uegodawa · Post by **uegodawa** » Thu Feb 05, 2009 2:56 pm

1. Can you specify the data types of input and output of 'SNo' field.
2. What's derivation you used in Modify stage ?

kittu.raja · Post by **kittu.raja** » Thu Feb 05, 2009 3:03 pm

uegodawa wrote:1. Can you specify the data types of input and output of 'SNo' field.
2. What's derivation you used in Modify stage ?

Input data type is Double
Output datatype is Integer

In the derivation I used SNo=SNo as Modify uses a default conversion rule for this conversion.

uegodawa · Post by **uegodawa** » Thu Feb 05, 2009 3:54 pm

Okay you are trying to assign double to int.
double can store upto 8 bytes
int can store upto 4 bytes.
Suppose your input has 6 bytes. Can you store that value into a int type variable ?

In your case either you need to chnage int to double or double to int , depend on your requirement. Otherwise use a Transformer stage with following function
AsInteger().

ray.wurlod · Post by **ray.wurlod** » Thu Feb 05, 2009 4:42 pm

SHOW us what you are attempting in the Modify stage: input and output data type plus specifications.

Are you using a NOWARN specification?

kittu.raja · Post by **kittu.raja** » Fri Feb 06, 2009 3:20 pm

[quote="uegodawa"]Okay you are trying to assign double to int.
double can store upto 8 bytes
I will be getting 4 bytes of data thats for sure. Now what should I do

kittu.raja · Post by **kittu.raja** » Fri Feb 06, 2009 3:21 pm

[quote="ray.wurlod"]SHOW us what you are attempting in the Modify

Input data type double
Output data type Integer
specification SNo=SNo

SNo is the column name.

kittu.raja · Post by **kittu.raja** » Fri Feb 06, 2009 3:22 pm

[quote="ray.wurlod"]SHOW us what you are attempting in the Modify

I am not using any warn specification

ray.wurlod · Post by **ray.wurlod** » Fri Feb 06, 2009 3:23 pm

kittu.raja wrote:I am not using any warn specification

Would you like to try one?

It's the single word NOWARN as a separate Specification.

Still waiting for you to post your actual Specifications so we can check them to see if the problem might be there.

uegodawa · Post by **uegodawa** » Fri Feb 06, 2009 3:42 pm

I will be getting 4 bytes of data thats for sure. Now what should I do

Then you can make data type as Integer on both sides.