Page 1 of 1
Posted: Thu Jul 20, 2006 10:29 pm
by loveojha2
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?
Posted: Thu Jul 20, 2006 10:35 pm
by rcil
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.
Posted: Thu Jul 20, 2006 11:06 pm
by loveojha2
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?
Posted: Thu Jul 20, 2006 11:39 pm
by rcil
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?
Posted: Fri Jul 21, 2006 12:21 am
by ray.wurlod
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.