- #Flat file comparison tool pro
- #Flat file comparison tool code
- #Flat file comparison tool license
In this next example I have created another file, TESTFILE2, with a slightly different layout: It will return just one row to say that difference(s) have been foundĪs the two files are identical there are no differences and no results are returned:
QUICK If you just want to check if the data in the two files is different use this. YES: Compare the data and return one row of results for each difference found. Like the previous parameter this one also has three possible values: Line 8: I am only interested in the layout of the two files in this example, therefore, the COMPARE_DATA is NO. It will return just one row to say that difference(s) have been found QUICK If you just want to check if the two files are different use this. YES: Compare the attributes and return one row of results for each difference found. Line 7: The COMPARE_ATTRIBUTES can have three possible values: Lines 2 – 6: I think it is obvious what is going on with these parameters. 
ATTRIBUTE_NAME: Name of the difference between the two files. Line 1: There are three columns returned in the results from this table function: 
Now I can use the table function to compare the two files: I created the copy of TESTFILE using the Create Duplicate Object command:ĬRTDUPOBJ OBJ(TESTFILE) FROMLIB(MYLIB) OBJTYPE(*FILE) In my first scenario I am going to compare two identical files.
In preparing the examples of code I did try all kinds of other scenarios of differences between files and was very impressed with what I found.įirst I will need a simple file to which I can compare other to: I am just going to give some simple examples in this post.
PARALLEL_DEGREE This is another parameter I am just going to say omit this. COMPARE_DATA: Compare the data in the files. COMPARE_ATTRIBUTES: Compare the layout of the two files. RDB2: Did not see the purpose of the parameter when comparing files in the same partition, I am just going to say omit this. LIBRARY2: Library that contains the second file. LIBRARY1: The library that contains the first file to be used in the comparison. It is not available in IBM i 7.3 TR8.ĬOMPARE_FILES has a number of parameters: Wow, both of those with the same table function!Īlas, it is only available in the Technology Refresh for 7.4 only, IBM i 7.4 TR2. I can compare two files layout and the data within them with this table function, and have a results row returned for each difference. Technician Perpetual License License is valid for lifetime usage starting from the purchase date.Having looked at, and played, with a number of the new additions to Db2 for i in the latest new Technology Refresh this is my favorite and in my opinion the most useful: table function COMPARE_FILE.ĬOMPARE_FILE gives me the ability to identify differences between physical files, source files, and DDL (SQL) tables. This subscription will be automatically renewed unless licensee unsubscribes before the next term. Enterprise Annual Subscription License is valid for one-year usage starting from the purchase date. Server Perpetual License License is valid for lifetime usage starting from the purchase date.
Pro Ultimate Perpetual License License is valid for lifetime usage starting from the purchase date. Pro Platinum Annual Subscription License is valid for one-year usage starting from the purchase date. Pro Deluxe Annual Subscription License is valid for one-year usage starting from the purchase date. Pro Annual Subscription License is valid for one-year usage starting from the purchase date.
0 kommentar(er)
