Oninit cdi / Archive
Talk to an expert →

Can some body please help translate this into an I

Posted in 2008

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

Korrapati, — — source: IIUG Forums & Mailing Lists

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') Thank you, NK

↪ replying to Korrapati,
Art Kagel — — source: IIUG Forums & Mailing Lists

Translate into... What? QUEL? Russian? Older SQL syntax? I'm guessing that the mailing list truncated your Subject. Better to put your question into the text itself. Also, when you repost, don't forget IDS version and your platform information. Art On Mon, Sep 29, 2008 at 4:04 PM, Korrapati, Nareshkumar < Nareshkumar.Korrapati@xerox.com> wrote: > 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') > > Thank you, > NK > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

↪ replying to Art Kagel
Everett — — source: IIUG Forums & Mailing Lists

This is his post to the news group. It looks like he's moving an app from SQueaL server to IDS: 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') > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art > Kagel > Sent: Monday, September 29, 2008 3:45 PM > To: ids@iiug.org > Subject: Re: Can some body please help translate this i.... [13515] > > Translate into... What? QUEL? Russian? Older SQL syntax? I'm guessing > that the mailing list truncated your Subject. Better to put your question > into the text itself. Also, when you repost, don't forget IDS version and > your platform information. > > Art > > On Mon, Sep 29, 2008 at 4:04 PM, Korrapati, Nareshkumar < > Nareshkumar.Korrapati@xerox.com> wrote: > > > 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') > > > > Thank you, > > NK > > > > > > > > > ************************************************************************ ** > ***** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Art S. Kagel > Oninit (www.oninit.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Oninit, the IIUG, nor any other > organization > with which I am associated either explicitly or implicitly. Neither do > those opinions reflect those of other individuals affiliated with any > entity > with which I am affiliated nor those of the entities themselves. > > > ************************************************************************ ** > ***** > Forum Note: Use "Reply" to post a response in the discussion forum.