Translation to Informix Query

Can somebody please help translate this query ( for SQL Server ) for use with Informix SELECT DISTINCT dbo.typeclass.name AS TypeClass, dbo.device.name, dbo.device.description, dbo.devicenumplanmap.display, dbo.numplan.dnorpattern, dbo.typemodel.name AS TypeModel,dbo.typedeviceprotocol.name AS TypeDeviceProtocol FROM dbo.typedeviceprotocol RIGHT OUTER JOIN dbo.device RIGHT OUTER JOIN dbo.numplan RIGHT OUTER JOIN dbo.devicenumplanmap ON dbo.numplan.pkid = dbo.devicenumplanmap.fknumplan ON dbo.device.pkid = dbo.devicenumplanmap.fkdevice LEFT OUTER JOIN dbo.typemodel ON dbo.device.tkmodel = dbo.typemodel.enum LEFT OUTER JOIN dbo.typeclass ON dbo.typemodel.tkclass = dbo.typeclass.enum ON dbo.typedeviceprotocol.enum = dbo.device.tkdeviceprotocol WHERE (dbo.typeclass.name = 'Gateway') AND (dbo.typemodel.name <> 'H.323 Gateway')

Hello Korrapati, I'm guessing that you know SQL Server but not Informix. If that is the case then just remove the "dbo." from everywhere and the query should work in Informix (if the tables exist in the same way in both places). Also cruise the web to read up on "Informix dbaccess". L.S.