date conversion

[deva]

Are you talking about a NULL or an empty string? The former, in Server, can only occur if the input is already NULL! ...

I am loading 50 records from file. I have data for begin date. If I am loading in to database I am getting the following err.

I am using the following derivation :

Oconv(Iconv(DSLink44.BEGIN_DATE,"D/E"), "D4/MDY")

for this I am getting follwoing error.

Db_ReInsurance_PP..Risk_Tfm: At row 45, link "Risk_out", while processing column "BEGIN_DATE"
Value treated as NULL
Attempt to convert String value "" to Date type unsuccessful


IF ANY ONE NOT STILL UNDERSTAND PLSEASE LET ME KNOW

[ArndW]

<sigh> The DataStage value is an empty string. DataStage doesn't care about data types so accepts that value. When that is being written to your Database it won't accept that invalid date, hence it uses NULL.

You need to fix your derivation so that it results in a valid date in the correct format. Your current derivation doesn't handle invalidly formatted input dates.

[paddu]

Deva,

Based on the assumption that your input value looks like DD/MM/YYYY , i made the date to get loaded into oracle.

May not be the absolute solution but try this ..

use the below function in the transfomer derivation of the Date field to be loaded.


Field(BEGIN_DATE,'/',3,1):Field(BEGIN_DATE,'/',2,1):Field(BEGIN_DATE,'/',1,1)

Thanks
Paddu