njcncadmin
Active Member
We have a bunch of older interactive and batch versions in Production that have version security set to 1 and the userid in the USER column in BV is a userid that no longer exists. Rather than recreating the necessary userids and going through a bunch of checkouts and checkins, we'd like to use SQL instead.
We know that the USER column is actually the VRUSR0 column in the F983051. Using SQL, we plan on just updating VRUSR0 to a generic userid that will never get deleted. Does anyone see any potential issue with using SQL to do this?
Our new process is to make sure all new versions that need version security set to something other than 0 will be owned by the generic userid prior to migrating to Production.
We know that the USER column is actually the VRUSR0 column in the F983051. Using SQL, we plan on just updating VRUSR0 to a generic userid that will never get deleted. Does anyone see any potential issue with using SQL to do this?
Our new process is to make sure all new versions that need version security set to something other than 0 will be owned by the generic userid prior to migrating to Production.