How To Compare Field Values Between Tables

Read Time:24 Sec

I used the following SQL to compare the difference between the F9200 (Data Dictionary) used for EnterpriseOne 9.1 and the one used for EnterpriseOne 8.12 that I copied to the SQL Server using R98403:

SELECT a.FRDTAI,a.FRCDEC AS a_FRCDEC, b.FRCDEC AS b_FRCDEC 
FROM JDE910.DD910.F9210 a 
INNER JOIN DD812.PRODDTA.F9210 b ON 	
(a.FRDTAI COLLATE DATABASE_DEFAULT = b.FRDTAI COLLATE DATABASE_DEFAULT) 
WHERE a.FRCDEC COLLATE DATABASE_DEFAULT  b.FRCDEC 
COLLATE DATABASE_DEFAULT

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA  What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Previous post SQL Server Error: Cannot resolve the collation conflict between "Latin1_General_CI_AS_WS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation
Next post Upgrade Gotcha: Media Objects