Warning converting decimal to date
Posted: Thu Oct 09, 2008 9:32 am
Problem Description:
------------------------
no warnings on DS 7.5 but warnings produced on DS 7.5.3 while using the same code
Warning: APT_CombinedOperatorController,1: Conversion error calling conversion routine date_from_string data may have been lost
Transformation used to convert DECIMAL(8,0) to a date
-----------------------------------------------------------------
If IsNull(lkread_L2OE.L2OE_INS_EFF_DATE)
Then SetNull()
Else (If DateToString(StringToDate(DecimalToString(lkread_L2OE.L2OE_INS_EFF_DATE,"suppress_zero") ,"%yyyy%mm%dd"),"%yyyy%mm%dd")="********"
Then SetNull()
Else StringToDate(DecimalToString(lkread_L2OE.L2OE_INS_EFF_DATE,"suppress_zero") ,"%yyyy%mm%dd"))
The results are as expected but I am getting warnings on the job-log, please let me know how I can get rid of these warnings
------------------------
no warnings on DS 7.5 but warnings produced on DS 7.5.3 while using the same code
Warning: APT_CombinedOperatorController,1: Conversion error calling conversion routine date_from_string data may have been lost
Transformation used to convert DECIMAL(8,0) to a date
-----------------------------------------------------------------
If IsNull(lkread_L2OE.L2OE_INS_EFF_DATE)
Then SetNull()
Else (If DateToString(StringToDate(DecimalToString(lkread_L2OE.L2OE_INS_EFF_DATE,"suppress_zero") ,"%yyyy%mm%dd"),"%yyyy%mm%dd")="********"
Then SetNull()
Else StringToDate(DecimalToString(lkread_L2OE.L2OE_INS_EFF_DATE,"suppress_zero") ,"%yyyy%mm%dd"))
The results are as expected but I am getting warnings on the job-log, please let me know how I can get rid of these warnings