webMethods, OneData, and Terracotta  10.2 | Managing Master Data with webMethods OneData | webMethods OneData User’s Guide | Working with Data Objects in Default Mode | Editing Records | Updating Bulk Records
 
Updating Bulk Records
The Update Bulk feature allows you 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 the Values tab to display all the records associated with the object.
*Enter filtering criteria to display only records that match specific values and click Next.
4. Select the records to update and click Edit > Bulk Update.
5. Apply updates to fields, as needed. Use the appropriate update options for the data type as described in the following table. The NULLIFY option overwrites any existing value with a null value.
Data Type
Update Bulk Options
Sequences
N/A except for Optional Database Sequence. Bulk-assign a sequence value.
Numeric
Bulk-assign numeric values or NULLIFY existing values.
Varchar
Bulk-assign varchar 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. Boolean columns display as a drop down on the update bulk screen.
Note: If the boolean column is selected to display as list, the update bulk option includes and Ignore option (to omit the column while updating).
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