![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
differences = DIFF_DATA(table1, field1, location1, selection1, table2, field2, location2, selection2, printresult)
On return, contains N if there are no differences and Y if there are any differences. The actual differences, if any, are listed in the message log. The name of the first table or table instance to be compared. Valid values are: Specific fields within table1 to compare. Valid values are:
• fieldnames – Indicates the comparison is based on primary key values and the fields specified in field1 and field2. Specify a series of fieldnames in the format: fieldname fieldname fieldname. The name of the node where table1 is located. A selection string used to designate which occurrences in table1 are to be used for comparison. Valid operators are: The name of the second table or table instance to be compared. Valid values are the same as for table1. The name of the node where table2 is located A selection string used to designate which occurrences in table2 are to be used for comparison. Valid operators are the same as for selection1.
• If the tables specified in table1 and table2 are parameterized, specify only the data parameters, not the location parameters.
•
• DIFF_DATA can fail if you do a comparison for all fields between tables whose definitions differ.
• In the output, the letters D and I indicate which items are to be deleted or inserted to make the specified data of table2 match the specified data of table1.
• There are an unequal number of fields listed for the two tables being comparedThis example compares the primary key fields and the DEPTNO fields within each occurrence and returns the results of the comparison to the message log:
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |