How to convert the below Oracle Query to DB2. The Query is working fine in Oracle but not in DB2. Please Help.
Query:
Code:
Select f.folder_id, f.identifier From FOLDER f, STOREENT se Where f.type = 'AttributeFolder' And se.storeent_id = f.storeent_id And se.identifier = 'Global_CAS' And f.identifier = 10051 connect by prior f.folder_id = f.parentfolder_id