SmallInt Datatype

neena · Post by **neena** » Thu Oct 16, 2008 8:25 am

When I tried to insert a character 'Y' into Smallint datatype column, i thought it would throw an error because the datatype is small integer but it hasn't, am i missing anything?

I did a test jobs around this, In transformer column derivation I hardcoded the value as 'Y' which has SmallInt as datatype. It hasn't given a warning.

Any suggestions will be greatly appreciated. Thanks.

neena · Post by **neena** » Thu Oct 16, 2008 8:50 am

when i send characters for datatype column SmallInt it always giving me Zero as output.
But when i hardcod as '1'or '2' ' its giving me correct result.
That explains some thing which i dont know. Thanks.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 16, 2008 2:14 pm

What is the target? In particular is the target a text file or something else?

neena · Post by **neena** » Fri Oct 17, 2008 3:57 pm

Hi Ray,

The target, I tested with Dataset and Sequential file. I even tested with datatypes integer, decimal and double, its writing out Zero for Alpha Characters.
Job is finishing ok with no warnings, but its giving an informational message.

APT_CombinedOperatorController,0: Numeric string expected . Use default value.
Numeric string expected . Use default value.

So with that said, If I use a function like StringTo Decimal() and if source data is having alpha characters will that be converted into zero then? without giving any warnings? Can we ignore this kind of messages, if we are not concerned about data that is being populated into target?
The reason i am asking this question is because of the below post. Thank you much Ray for your reply.
viewtopic.php?t=122327&highlight=numeri ... g+expected