Hi

I can create a local view

	CREATE SQL VIEW V_HOLSSTD_ALL AS ;
		SELECT Holsstd.s_key, ;
			Holsstd.descr, ;
			Holsstd.day, ;
			Holsstd.htype, ;
			Holsstd.month, ;
			Holsstd.dow, ;
			Holsstd.wom, ;
			Holsstd.adjust, ;
			Holsstd.country, ;
			Holsstd.region, ;
			Holsstd.active, ;
			CAST(IIF(day>0, day, wom*10+dow) AS N(2)) AS seq ;
		FROM wots!holsstd ;
		ORDER BY Holsstd.month, 12

but when I try to create it as a remote view

	CREATE SQL VIEW V_HOLSSTD_ALL REMOTE CONNECTION rWots SHARE AS ;
		SELECT Holsstd.s_key, ;
			Holsstd.descr, ;
			Holsstd.day, ;
			Holsstd.htype, ;
			Holsstd.month, ;
			Holsstd.dow, ;
			Holsstd.wom, ;
			Holsstd.adjust, ;
			Holsstd.country, ;
			Holsstd.region, ;
			Holsstd.active, ;
			CAST(IIF(day>0, day, wom*10+dow) AS N(2)) AS seq ;
		FROM wots!holsstd ;
		ORDER BY Holsstd.month, 12

I get a error odbc connectivity error - Function is missing ).

Can someone enlighten me as to why?

Thanks in advance
Geoff Scott