Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

Make it NULL by default

For some business reason i have to either avoid values updating a column in a table. I cannot controt the data import, all i am trying to do is make that column to null whatever value it has.. the column should always have null, so either i can avoid the incoming fileds or change it after feed.. so is there any way to do that?
0
parpaa
Asked:
parpaa
  • 3
1 Solution
 
Philip PinnellCommented:
You could have a trigger on update that changes the value back to null whenever an attempted update takes place.
0
 
parpaaAuthor Commented:
is there anything else besides this?? this sounds good...
0
 
Philip PinnellCommented:
I can't think of another sure way
0
 
Philip PinnellCommented:
Thanks
0
 
aangrishCommented:
As you don't have control over the import, a before insert or update trigger is the way to go. Depending on your database, ensure it fires only on an update to that particular field.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now