IBM BJ0NJML Integration Guide - Page 217

SET action, REPLACE action, COMBINE action

Page 217 highlights

SET action REPLACE action COMBINE action SPLIT action Processing Rule Definitions The following field transformation actions manipulate data fields within a message. The set action writes a value to a specified data field. When you define the rule, you specify the data to be set and the source of the new value. Indicate whether the rule always writes the new value to the target field or writes the new value only when the field is null (the default action). You can use this action to initialize the value in a data field. If the rule always writes the new value to the target field, any existing value in the field is overwritten. The source can be one of the following values: T A value integration control T A hard-coded value T A system control (in the MAXVARS database table) T Another field in the specified record or object T A field in a related object The replace action replaces a value in a data field with another value. When you define the rule, you specify the data field that you want to update. The control that you use must be a cross-reference control. You specify the name of a crossreference control that contains the original and replacement values for the data field. Use this action when an external system and the system have different identifiers for the same entity. For example, the plant identifier of an external system might translate to your site identifier. For example, to replace the SITEID value in a publish channel with an external PLANTID value, and to replace the external PLANTID value in an enterprise service with a SITEID value, you can use a single cross-reference control. The combine action concatenates values from multiple source fields into a single target field. When you define the rule, you identify the target field and the source fields. You also identify the sequence in which the source data is to be written to the target field. The source data can be a data field or an integration control that contains a data value. You can also specify an integration control that contains the delimiter to separate the segments in the target field. Use this action in an enterprise service processing rule when a mismatch exists between the system definition and the external system definition of an entity, for example, a two-part external system key that maps to a single part key in the system. An enterprise service processing rule can combine a vendor ID and a vendor location field from an external system into the COMPANY field. A publish channel processing rule with the split action can then separate the combined field into separate values when data is sent to the external system. The source and target fields must be in the same object. This action always overwrites the existing value in the target field. Ensure that the source and target fields are alphanumeric fields, or processing errors may occur. The split action is the reverse of the combine action. The split action separates the value in one field into multiple fields. When you define the rule, you identify one Integration Framework Customization with Processing Rules 203

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280
  • 281
  • 282
  • 283
  • 284
  • 285
  • 286
  • 287
  • 288
  • 289
  • 290
  • 291
  • 292
  • 293
  • 294
  • 295
  • 296
  • 297
  • 298
  • 299
  • 300
  • 301
  • 302
  • 303
  • 304
  • 305
  • 306
  • 307
  • 308
  • 309
  • 310
  • 311
  • 312
  • 313
  • 314
  • 315
  • 316
  • 317
  • 318
  • 319
  • 320
  • 321
  • 322
  • 323
  • 324
  • 325
  • 326
  • 327
  • 328
  • 329
  • 330

Processing Rule Definitions
Integration Framework Customization with Processing Rules
203
The following field transformation actions manipulate data fields within a
message.
SET action
The set action writes a value to a specified data field. When you define the rule,
you specify the data to be set and the source of the new value. Indicate whether
the rule always writes the new value to the target field or writes the new value
only when the field is null (the default action). You can use this action to initialize
the value in a data field.
If the rule always writes the new value to the target field, any existing value in the
field is overwritten.
The source can be one of the following values:
A value integration control
A hard-coded value
A system control (in the MAXVARS database table)
Another field in the specified record or object
A field in a related object
REPLACE action
The replace action replaces a value in a data field with another value. When you
define the rule, you specify the data field that you want to update. The control
that you use must be a cross-reference control. You specify the name of a cross-
reference control that contains the original and replacement values for the data
field.
Use this action when an external system and the system have different identifiers
for the same entity. For example, the plant identifier of an external system might
translate to your site identifier.
For example, to replace the SITEID value in a publish channel with an external
PLANTID value, and to replace the external PLANTID value in an enterprise
service with a SITEID value, you can use a single cross-reference control.
COMBINE action
The combine action concatenates values from multiple source fields into a single
target field. When you define the rule, you identify the target field and the source
fields. You also identify the sequence in which the source data is to be written to
the target field. The source data can be a data field or an integration control that
contains a data value. You can also specify an integration control that contains the
delimiter to separate the segments in the target field.
Use this action in an enterprise service processing rule when a mismatch exists
between the system definition and the external system definition of an entity, for
example, a two-part external system key that maps to a single part key in the
system.
An enterprise service processing rule can combine a vendor ID and a vendor
location field from an external system into the COMPANY field. A publish
channel processing rule with the split action can then separate the combined field
into separate values when data is sent to the external system.
The source and target fields must be in the same object.
This action always overwrites the existing value in the target field. Ensure that the
source and target fields are alphanumeric fields, or processing errors may occur.
SPLIT action
The split action is the reverse of the combine action. The split action separates the
value in one field into multiple fields. When you define the rule, you identify one