MSCEWI3003

Non-ANSI outer join syntax converted to ANSI syntax.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

This issue happens when a non-ANSI outer join syntax is used. Depending on the order of the selected tables, the converted query may show the columns in a different order.

Example Code

Input Code:

SELECT d.department_name,
       e.employee_name      
FROM   departments d, employees e
WHERE  d.department_id = e.department_id (+);

Output Code:

SELECT d.department_name,
       e.employee_name
       /*** MSC-WARNING - MSCEWI3003 - NON-ANSI OUTER JOIN SYNTAX CONVERTED TO ANSI SYNTAX ***/
       FROM PUBLIC.departments d LEFT OUTER JOIN PUBLIC.employees e ON  d.department_id = e.department_id;

Recommendations

• If the columns are required in a specific order, try selecting explicitly each column in the required order.

• Check for the equivalence of the output of the source and converted code.

• If you need more support, you can email us at [email protected]