Note: This applies to MySql version 5.7. See the comments section of this post for version 8.0. I have been looking for a portable version MySql database which I can just copy on my machine and start using with installation. It took a little bit of effort to make it work. Here are the steps…
When writing SQL queries, I prefer the JOIN clause syntax over (+) in where clause for creating table joins. It is more readable and maintainable as join logic is separated from the where clause. BusinessObjects Universe can be configured to generate JOIN clause (ANSI92) syntax by setting a parameter in ‘Universe Parameters’ dialog available from…
A complex join contains more than one condition in the join expression. Consider the following expression where one line of sales order joins with a line on invoice, INVOICE_LINE.ORDER_NUM=ORDER_LINE.ORDER_NUM and INVOICE_LINE.ORDER_LINE_NUM=ORDER_LINE.ORDERLINENUM If we define a complex join in BusinessObjects Universe Design Tool, than the option to make it outer becomes disabled. There are three possible…
An essential aspect of creating a BusinessObjects universe is to define joins among tables in ‘Universe Design Tool’. Even if the joins are correctly defined from relational point of view, the universe might not generate the correct results in certain cases. There are few pitfalls to avoid which are specific to the business of designing universe. These pitfalls,…
While designing SAP BusinessObjects universe with Universe Design Tool, Chasm Trap is one of the major join problems that one can come across. We are in Chasm Trap when a table joins with two others in one-to-many relationship. Chasm Trap produces more data than expected. Example Consider the following ER diagram where DEPARTMENT is having 1-to-many…
DBMS_OUTPUT.PUT_LINE can be used to write to console. It works if server output is on: set serveroutput on size 30000;