Register FAQ Memberlist Search Linoma Software Forum Index

Linoma Software Forum Index -> Crypto Complete -> Maintenance on a database file with SQL Triggers
This forum is locked: you cannot post, reply to, or edit topics.  This topic is locked: you cannot edit posts or make replies. View previous topic :: View next topic 
Maintenance on a database file with SQL Triggers
PostPosted: 01/02/08 03:14:02 PM Reply with quote
Support
Site Admin
 
Joined: 12 Mar 2004
Posts: 378
Location: Omaha, NE


What kind of maintenance can I perform on a database file with SQL Triggers on it?

1. The operating system will not allow you to perform a CLRPFM (Clear Physical File Member) command on your database file if it has a Delete trigger on it. A Delete trigger will be on the file if you chose to store the encrypted field values in an external file when defining it the Field Encryption Registry. If you want to remove all the records from the file, you should perform a mass delete through a programming language or use a SQL Delete command.

2. Do not rename or move a database file if one or more of its fields are activated in the Field Encryption Registry. In order to keep the Field Encryption Registry ?in sync? with the new file location, you should follow these steps:

a. Deactivate the field in the Field Encryption Registry.

b. Rename or move the database file object.

c. Change the entry in the Field Encryption Registry with the new file location.

d. Activate the field in the Field Encryption Registry.

3. Do not perform a CRTDUPOBJ (Create Duplicate Object) command with TRG(*YES) specified. This action would duplicate the triggers to the new object, which would confuse the Field Encryption Registry and the encryption processes. Data may be lost.
View user's profile Send private message Send e-mail Visit poster's website
Maintenance on a database file with SQL Triggers
  Linoma Software Forum Index -> Crypto Complete
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 6 Hours  
Page 1 of 1  

  
  
 This forum is locked: you cannot post, reply to, or edit topics.  This topic is locked: you cannot edit posts or make replies.  



Powered by phpBB 2.0.6 © 2001-2003 phpBB Group Style created by Vjacheslav Trushkin