webMethods, OneData, and Terracotta  10.2 | Managing Master Data with webMethods OneData | webMethods OneData User’s Guide | Working with Data Objects in Nova Mode | Editing Records | Bulk Updating Records
 
Bulk Updating Records
Use the update bulk feature to update one or more columns with the same value(s) simultaneously. For example, if you want the records in the result set to have the same start and end dates, you can use the update bulk feature.
* To perform a bulk update on records
1. On the Menu toolbar, click Manage > Manage Data.
2. Navigate to the object that you want to edit and select it.
3. Display the records associated with the object, doing one of the following:
*Click Display Values to display all the records associated with the object.
*Enter filtering criteria to display only records that match specific values and click Apply Filter.
4. Select the records to update and click Edit > Bulk Update.
5. Apply updates to fields, and use the option that corresponds to the data type as describe in the following table. NULLIFY overwrites existing values with a null value.
Data Type
Update Bulk Options
Sequences
Does not apply except for Optional Database Sequence. Bulk-assign a sequence value.
Numeric
Bulk-assign numeric values or NULLIFY existing values.
Varchar
Bulk-assign text, NULLIFY fields, or apply the update as follows:
*Prefix With: Adds the specified prefix to existing values.
*Suffix With: Adds the specified suffix to existing values.
*RPAD: Pad values right (for example: trailing zeros).
*LPAD: Pad values left (for example: leading zeros).
Char
Bulk-assign char text or NULLIFY existing values.
Date
Bulk-assign date or NULLIFY existing values.
Boolean
Bulk-assign YES or NO. Select Ignore to omit this column during the update.
BLOB/CLOB
Bulk-attach the files.
Note: Primary keys cannot be updated and therefore do not display in the Update Bulk screen. Required fields cannot be assigned the NULLIFY attribute.
6. Click Save.

Copyright © 2011-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release