Hey guys I keep getting an error -106 on some SQLs swhen I try and use the db2advisor on them. I've seen the APAR about TABS but there's no tabs in these SQLs (others work fine).
Here's an example
select * from asset where location = 'CUST1' and siteid= 'MAIN' and status not in ( 'DECOMMISSIONED' ) and (parent is null or not exists (select 1 from asset q where q.assetnum=asset.parent and q.location = 'CUST1' and q.siteid= 'MAIN' ))
Anyone got any ideas? I can't apply any patches due to compatibility issues with some of the other apps in the system... any workaround ideas?
Last edited by meehange; 12-15-09 at 00:47.
Reason: error in prob desc