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
Insert / Update
Moderators: chulett, rschirm, roy
Re: Insert / Update
try using 'DSJobStartDate' DSMacro in your transformer , not in SQL and use 2 seperate paths for Update and Insert logic.
Re: Insert / Update
You were doing the right thing in that case, But are you taking care of converting the sysdate to your out column datatype?
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.
to_char(sysdate, format you want) or to_date(sysdate, format you want).
Kris~
~Kris