![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
• Table SALES2011 is an IMS table that might contain uninitialized packed decimal data represented as low values. To ignore that invalid data, set the Data Cleansing field in the Table Definer to LOW. The input character data will be unchanged.
• Table MYIMP1 is an IMP table that contains character data you would like to clean up before processing it. In addition, to ignore any invalid numeric data, set the Data Cleansing field to INV,TRLOAD=CLEANUP. The load module CLEANUP is based on the following Assembler source file:
CLEANUP CSECTTABLE1 DC 256AL1(*-TABLE1)TABLE2 DC XL256'00'
Using this definition, any carriage returns, line feeds, or form feeds will be removed from the input data before processing. Also, several undesirable characters will be replaced with blanks should they exist in the input data.
• Table MAP47 is a MAP table with character fields that contain X'FF', which you would like to remove. To do so, set Data Cleansing for the table definition to TRTAB=NOFF.
• Table instance @TRTABLES(NOFF) contains one occurrence with the field TYPE = 'DELETE' and the field TRTABLE that contains a 256-byte string with the first 255 bytes zero and the last one, non-zero.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |