The predicate:
Code: Select all
Z LEFT OUTER JOIN Z6 ON PTY = PARTY AND @DECODE( CITY, 'B', 'Z', 'fm', 'fn', CITY ) = @DECODE( MCITY, 'B', 'Z', 'fm', 'fn', MCITY )
However with a (+) I get this error:
Code: Select all
PTY = PARTY(+) AND @DECODE( CITY, 'B', 'Z', 'fm', 'fn', CITY ) = @DECODE( MCITY, 'B', 'Z', 'fm', 'fn', MCITY ) (+) AND
^
Error: 00901 PRS CNE Command not properly ended