Hi,
I have an Advanced DSO loaded with about 50 million records and I would like to update a subset of these records with new values.
I am going to maintain a table that will have Field Names, Original Value and New Value. The number of fields can be dynamic (Usually 2 or 3).
I was thinking I would be able to build a dynamic SQL or SQLScript from this table and update the records in the DSO Table.
My concern is would this be a problem if the DSO is flagged for activation.
Thanks for any insights or suggestions!
Update 1
<DSO_FIELD_NAME_1>
<ORIGINAL_VALUE_1>
<NEW_VALUE_1>
Update 1
<DSO_FIELD_NAME_2>
<ORIGINAL_VALUE_2>
<NEW_VALUE_2>
Update 1
<DSO_FIELD_NAME_3>
<ORIGINAL_VALUE_3>
<NEW_VALUE_3>
Update 1
<DSO_FIELD_NAME_...>
<ORIGINAL_VALUE_...>
<NEW_VALUE_...>
Update 2
<DSO_FIELD_NAME_1>
<ORIGINAL_VALUE_1>
<NEW_VALUE_1>
Update 2
<DSO_FIELD_NAME_2>
<ORIGINAL_VALUE_2>
<NEW_VALUE_2>
Update 2
<DSO_FIELD_NAME_3>
<ORIGINAL_VALUE_3>
<NEW_VALUE_3>
Update 2
<DSO_FIELD_NAME_...>
<ORIGINAL_VALUE_...>
<NEW_VALUE_...>