We are trying to use BMC unload utility and trying to unload from 2 tables using join.
But we are getting error. The same SQL is running fine in Spufi.
Is it like we cannot use more than one table in BMC unload?
we actually got is solved by using DIRECT NO option instead of Share.
But still am not sure why it gave error when used with Share. here is the SQL - the error one
SHRLEVEL CHANGE CONSISTENT NO QUIESCE
FROM owner1.tblA A
WHERE A.Field1 BETWEEN '1 ' AND '19999999'
AND A.Field2 = B.field2
AND A.Field3 = '9999-12-31'
AND B.Field2 = 'A'