I am running a union query and have to have the same number of fields in the result fields for each query. I believe that you can use dummy objects within a class so as to make the queries compatible for a union. I am working over Oracle Financial universes on Oracle 7.3.4.
Can anybody help with setting up dummy objects with constant values?
Regards
Martin Silk
Decision Support Analyst
ntl: Midlands
You just create objects in designer and what I do is for numeric put a 0, for character, a “”, and for date just put some kind of generic date in it. (your dummy objects need to be the same format as the objects in the other query).
Julie Neumann
Hi Listers,
I am running a union query and have to have the same number of fields in the
result fields for each query. I believe that you can use dummy objects within a class so as to make the queries compatible for a union. I am working over Oracle Financial universes on Oracle 7.3.4.
Can anybody help with setting up dummy objects with constant values?
Martin,
Just define the dummy objects in your universe as character data types and use them in the reports at the appropriate place in the query. These objects wont compile individually in the universe so there is no use parsing them in Designer.
Rahul.
Mastercard International.
I am running a union query and have to have the same number of fields in the result fields for each query. I believe that you can use dummy objects within a class so as to make the queries compatible for a union. I am working over Oracle Financial universes on Oracle 7.3.4.