Insert / Update

[slaparna]

Hi,

I have a table on which I'm performing "Insert New rows or Update else". There is one column "Created Date" which needs to get populated when it is a new row. How can I stop updating that column when it is an existing row.

I tried of using the user defined sql by placing the "SYSDATE" in the insert SQL, but I am getting the warning "ORA-00911: invalid character"

Is there anyway I can use without using the hash file.
Any help would be appreciated.

Thanks,
Lakshmi

[y_suresh]

try using 'DSJobStartDate' DSMacro in your transformer , not in SQL and use 2 seperate paths for Update and Insert logic.

[kris]

I tried of using the user defined sql by placing the "SYSDATE" in the insert SQL, but I am getting the warning "ORA-00911: invalid character"

Is there anyway I can use without using the hash file.
Any help would be appreciated.

You were doing the right thing in that case, But are you taking care of converting the sysdate to your out column datatype?

to_char(sysdate, format you want) or to_date(sysdate, format you want).

Kris~