Re: Translation to Informix Query

Posted in 2008

Topics: SQL Development & Query Writing, Stored Procedures & SPL

DL Redden — Mon, 29 Sep 2008 14:39:22 -0700 (PDT) — source: Usenet: comp.databases.informix

Gee, I wish someone would help me do my job too. Try first, the come back with specific questions that would help you get through your issues. Start here, http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp, then search for inner join. That should get you moving down the right path. ----- Original Message ---- From: korrapati <nkorrapati@gmail.com> To: informix-list@iiug.org Sent: Monday, September 29, 2008 2:58:06 PM Subject: 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') _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to DL Redden

Rich — Tue, 30 Sep 2008 04:30:34 -0700 (PDT) — source: Usenet: comp.databases.informix

> ----- Original Message ---- > From: korrapati <nkorrap...@gmail.com> > To: informix-l...@iiug.org > Sent: Monday, September 29, 2008 2:58:06 PM > Subject: 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') > _______________________________________________ > Informix-list mailing list > Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list- Hide quoted text - > > - Show quoted text - http://www-01.ibm.com/support/docview.wss?uid=swg21195578 More appropriate?