Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Appendix C Data Cleansing : Options

Options
Two options for data cleansing are available, as follows:
Invalid numeric data can be ignored (the field in the table occurrence is set to a null value). This option can apply to all invalid numeric data or only to those whose input contains low values (all bytes X'00'). Numeric data are indicated by the fields with an external numeric syntax, that is, B, F, G, K, L, M, N, NL, NT, O, P, T, and U.
Character data can have undesirable characters removed or replaced. Character data are indicated by the fields with an external character syntax, that is, A, C, Q, V, W, X, and Z.
You can use the Table Definer to specify data cleansing for a particular table. The Data Cleansing field on the primary Table Definer screen specifies the data cleansing options for the table in question.
The possible options, which you can abbreviate, are as follows:
TRLOAD=modname — Load one or more translate tables from the load module with the name modname.
TRTABLE=iname — Load one or more translate tables from the @TRTABLES instance with the TRNAME parameter value iname.
For example, INV,TRL=MYTRANS denotes the following:
The translate tables to be used are specified as follows:
For a load module, which must be in a load library accessible to the DOB, there can be one or two entries, each 264 bytes long. Each entry contains an 8-byte blank padded field, which denotes the type of translate table, either REPLACE or DELETE, followed by a 256-byte translate table.
For a @TRTABLES instance, there can be one or two occurrences. The key field TYPE (IC8) can be REPLACE or DELETE. The field TRTABLE (V256) must contain the corresponding translate table.
If the type is REPLACE, then the 256-byte translate table represents a regular translate table in which each input data byte is replaced by the byte at the corresponding offset in the table.
If the type is DELETE, then the 256-byte translate table contains X'00' bytes for the characters that are to be retained, and non-zero bytes for the input characters that are to be deleted.
Please be aware that changes made to a translate table (either load module or @TRTABLES format) will not be seen by any active table that references that translate table. This is because the translation data is bound to the table definition when the table is first referenced by any user. To be certain of using the updated translate table, it may be necessary to recycle the DOB.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved