Converting Oracle Query to DB2 Query

[Venmathi]

Hi ,
How to convert the below Oracle Query to DB2. The Query is working fine in Oracle but not in DB2. Please Help.

Query:

    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
            start with f.identifier = 'Categories Descriptors [Global.B2C.Sales]'

Thanks In Advance
Venmathi

[Anas Mosaad]

Please check Serge's article on converting such queries http://www.ibm.com/developerworks/da...dm-0510rielau/

[manageknowledge]

I guess "connect by" is not supported in DB2, use JOIN.

[Anas Mosaad]

Connect by is supported in DB2 in the compatibility mode. This mode was added since 9.7. If you have 9.7 or later, you can use it if you enable the compatibility. If you have earlier versions or prefer not to go in the compatibility mode, you can use the details in Serge's article referenced earlier.

9.7 ===> http://www-01.ibm.com/support/knowle...7.html?lang=en

10.1 ===> http://www-01.ibm.com/support/knowle...7.html?lang=en

10.5 ===> http://www-01.ibm.com/support/knowle...7.html?lang=en