Skip to Content
0
Jun 10, 2015 at 10:23 PM

Possible to update Advanced DSO records with SQL/SQLSCRIPT

1895 Views

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.

  1. Would updating the DSO with SQL/SQLScript be a problem if it is flagged for activation? (SID Issues?)
    I'm guessing yes, but looking to hear from others

  2. Would it work fine if the DSO was not flagged for activation?
  3. Would it be better to just update the PSA Table instead (If we use one)?

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_...>