daywalker
Member
Hi all,
I have written some C++ code to list all business views and generate executable SQL code based on the BSVW blob contents.
The simple and outer joins are working, the selects are working, however I cannot seem to identify a Union within a BV. Would anyone know how to identify if two tables in a BV are UNIONed together?
I imagined initially that if JDE joins every column in each table and the number of columns are the same then it is a union... But the union I am testing with has 218 columns per table and only 113 joins.
Any ideas appreciated!
DayWalker
I have written some C++ code to list all business views and generate executable SQL code based on the BSVW blob contents.
The simple and outer joins are working, the selects are working, however I cannot seem to identify a Union within a BV. Would anyone know how to identify if two tables in a BV are UNIONed together?
I imagined initially that if JDE joins every column in each table and the number of columns are the same then it is a union... But the union I am testing with has 218 columns per table and only 113 joins.
Any ideas appreciated!
DayWalker