Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Translation to Informix Query

 
   Database Forums (Home) -> Informix RSS
Next:  SMF PHP error... Am I missing something subtle in..  
Author Message
korrapati

External


Since: Sep 29, 2008
Posts: 1



(Msg. 1) Posted: Mon Sep 29, 2008 12:58 pm
Post subject: Translation to Informix Query
Archived from groups: comp>databases>informix (more info?)

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')

 >> Stay informed about: Translation to Informix Query 
Back to top
Login to vote
LIGHT SCANS

External


Since: Sep 29, 2008
Posts: 6



(Msg. 2) Posted: Mon Sep 29, 2008 2:23 pm
Post subject: Re: Translation to Informix Query [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.

 >> Stay informed about: Translation to Informix Query 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
.NET TransactionScope -> ERROR [HY000] [Informix][Informix.. - Hi using Microsoft Enterprise Library Data access App Block i have this code using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { Database db1 = new GenericDatabase( ..

How to run Informix as a normal/unprivileged "informix" us.. - By default the user informix is in the admiistrators group, which is a security hole. if somebody compromises the database he will an administrative account for the whole server. My question is how do I run Informix IDS (10) when the informix user is..

Thanks (Why Informix is Best) - Hello to All of My Informix Friends Introducing myself I am just new in this IT field and along with Informix from the past 14 Months I thank to all of You because now i think i have got Enough Points When comparing Informix with other database. I....

Informix 4GL Help !! - Hi guys !! I have the following situation in my customer: - They have informix 5.10 and 4GL 4.20 and now they want to buy a new version of informix database (9.40 or 10) and 4GL (7.3x). But the problem is: Some 4GL programs doesn´t have the "prog...

Need Informix IDS 9.5 - I need Informix IDS 9.5 256 users.
   Database Forums (Home) -> Informix All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]