Error in type converstion

loveojha2 · Post by **loveojha2** » Thu Jul 20, 2006 10:29 pm

Hope I will be helped in fixing the below error.

That's obvious, no need to mention.

The input column is a decimal and I doing some calculations on a specific column and trying to load into the target table.

What sort of calculation is this, is it involving any other column also, what is the data type of that column?
Can a column involved in the calculation have a null?(just check)
What is the target field's data type?

rcil · Post by **rcil** » Thu Jul 20, 2006 10:35 pm

Thanks very much for the quick input.

I am trying to populate 3 columns using some simple calculations like addition, multiplication using another column which is of type decimal.

Code: Select all

Ex:

Col1 * Col2
Col1 * 100
Col2 * Col1

All the three target columns are of type decimal.

loveojha2 · Post by **loveojha2** » Thu Jul 20, 2006 11:06 pm

How are you guessing that the error is something to do with these columns only?
Is there any date column also within the target table?
Can that be causing problem?
What datatype you have specified for date fields?
What is your target database?

rcil · Post by **rcil** » Thu Jul 20, 2006 11:39 pm

I am not sure why and how but using the below function kind of solved the problem and loaded the records fine into the target database.

Oconv(Arg1, 'MD3')

Thanks again for all the inputs.

loveojha2 wrote:How are you guessing that the error is something to do with these columns only?
Is there any date column also within the target table?
Can that be causing problem?
What datatype you have specified for date fields?
What is your target database?

ray.wurlod · Post by **ray.wurlod** » Fri Jul 21, 2006 12:21 am

Read more (in Help, or in the DataStage BASIC manual) about the MD conversion. Perhaps this will aid you in understanding how the different specifications you use differ from each other.