Convert Integer to SmallInt

[donthula4u]

Hi , My Source is Oracle and the datatype is integer and my target is DB2 with Datatype as Small int .

How to convert it ? When i ran the job recrods are loading sucessfully . but i'm getting the below warnings .

Implicit conversion from source type "decimal[38,10]" to result type "int32": Possible range/precision limitation.

Please let me know how to convert from Integer to Smallint.

Thanks,

[chulett]

I split this from the post you decided to add it to. New problems = new posts, which also gives you the added bonus of being able to control the fate of the thread such as deciding when it is resolved.

Please take a moment to edit your post and add the particulars for your particular issue: DataStage version, operating system, etc.