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