Hi all

This is a typical condition I am having. I have shortlisted the problem to this view being used through ODBC by an external program. When used as below it will hang the external program using the view. Split the same view as further below and this view is usable in the external program. Why?!?

Culpirt view:

SELECT ROUND(LV_LKFCR1.BFCR1 / LV_LKFUELCONSTIME.BFCT, 2) AS BSFC1, ;
		LV_LKSRATINGTEST.IID ;
	FROM VSO3VIEWS!LV_LKTRATINGTEST ;
		JOIN VSO3VIEWS!LV_LKSRATINGTEST ;
				ON LV_LKTRATINGTEST.IID = LV_LKSRATINGTEST.IPID ;
		JOIN VSO3VIEWS!LV_LKFCR1 ;
				ON LV_LKSRATINGTEST.IID = LV_LKFCR1.IID ;
		JOIN VSO3VIEWS!LV_LKFUELCONSTIME ;
				ON LV_LKSRATINGTEST.IID = LV_LKFUELCONSTIME.IID

The same view individual fields work as below:

SELECT LV_LKFCR1.BFCR1 AS BSFC1, ;
		LV_LKSRATINGTEST.IID ;
	FROM VSO3VIEWS!LV_LKTRATINGTEST ;
		JOIN VSO3VIEWS!LV_LKSRATINGTEST ;
				ON LV_LKTRATINGTEST.IID = LV_LKSRATINGTEST.IPID ;
		JOIN VSO3VIEWS!LV_LKFCR1 ;
				ON LV_LKSRATINGTEST.IID = LV_LKFCR1.IID ;
		JOIN VSO3VIEWS!LV_LKFUELCONSTIME ;
				ON LV_LKSRATINGTEST.IID = LV_LKFUELCONSTIME.IID

SELECT LV_LKFUELCONSTIME.BFCT AS BSFC1, ;
		LV_LKSRATINGTEST.IID ;
	FROM VSO3VIEWS!LV_LKTRATINGTEST ;
		JOIN VSO3VIEWS!LV_LKSRATINGTEST ;
				ON LV_LKTRATINGTEST.IID = LV_LKSRATINGTEST.IPID ;
		JOIN VSO3VIEWS!LV_LKFCR1 ;
				ON LV_LKSRATINGTEST.IID = LV_LKFCR1.IID ;
		JOIN VSO3VIEWS!LV_LKFUELCONSTIME ;
				ON LV_LKSRATINGTEST.IID = LV_LKFUELCONSTIME.IID

Please advise