×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Need help to convert Oracle SQL to Informix SQL

Need help to convert Oracle SQL to Informix SQL

Need help to convert Oracle SQL to Informix SQL

(OP)
Hi, I need to convert following Oracle SQL to Informix SQL, Please help since i am facing problems with Outer join
Thanks in advance
Sandeep

Oracle SQL:
=====+++++

SELECT DISTINCT
PVC.PVC_ID,PVC.RSWITCH,PVC.RSLOT,PVC.RPORT,PVC.PVC_RDLCI,
PVC.PVC_RCONTRCIR,PVC.PVC_rVCI,PVC.PVC_rVPI,PVC.LSWITCH,PVC.LSLOT,
PVC.LPORT,PVC.PVC_LDLCI,PVC.PVC_LCONTRCIR,PVC.PVC_lVPI,PVC.PVC_lVCI,
VPNA.VPN_NAME AS AVPN_NAME,VPNZ.VPN_NAME ZVPN_NAME,IPFRA.VPN_ID AS AVPN_ID ,
IPFRZ.VPN_ID AS  ZAVPN_ID,SITEA.SITE_ID AS ASITE_ID ,SITEA.FULL_PORT_SPEED AS AFULL_PORT_SPEED,
SITEA.GRC AS AGRC,SITEA.CLLI AS ACLLI, SITEA.protocol Protocol_A, SITEZ.SITE_ID AS ZSITE_ID ,SITEZ.FULL_PORT_SPEED AS ZFULL_PORT_SPEED,SITEZ.GRC AS ZGRC,SITEZ.CLLI AS ZCLLIL, SITEZ.protocol Protocol_Z, CUSTOMERA.CUST_NAME AS ACUST_NAME ,CUSTOMERA.CUST_MCN AS ACUST_MCN,CUSTOMERA.CUST_ID AS ACUST_ID,CUSTOMERZ.CUST_NAME AS ZCUST_NAME ,
CUSTOMERZ.CUST_MCN AS ZCUST_MCN ,
CUSTOMERZ.CUST_ID AS ZCUST_ID,CUST_ACCESSA.ACC_CKT AACC_CKT,CUST_ACCESSz.ACC_CKT zACC_CKT,
PREMISEA.LOC_ID ALOC_ID, PREMISEA.PREM_ADDRESS APREM_ADDRESS,PREMISEA.PREM_CITY APREM_CITY,PREMISEA.PREM_STATE APREM_STATE,
PREMISEA.PREM_COUNTRY APREM_COUNTRY,PREMISEZ.LOC_ID ZLOC_ID, PREMISEZ.PREM_ADDRESS ZPREM_ADDRESS,
PREMISEZ.PREM_CITY ZPREM_CITY,
PREMISEZ.PREM_STATE ZPREM_STATE,PREMISEZ.PREM_COUNTRY ZPREM_COUNTRY,
VPNA.CUST_ID  VPNACUSTID, VPNZ.CUST_ID VPNZCUSTID,
IPFRA.CPE_IP_ADDRESS ACPEIPADDRESS, IPFRZ.CPE_IP_ADDRESS ZCPEIPADDRESS  

FROM
                         PVC     PVC               ,  
                             IPFR          IPFRA,
                             IPFR      IPFRZ,
                             VPN           VPNA,
                             VPN           VPNZ,
                             CUSTOMER      CUSTOMERA,
                             CUSTOMER      CUSTOMERZ,
                             CUST_ACCESS  CUST_ACCESSA,
                             CUST_ACCESS  CUST_ACCESSZ,
                             SITE         SITEA,
                             SITE        SITEZ,
                             PREMISE         PREMISEA,
                             PREMISE         PREMISEZ,
                             PORT_ASGMT     PORT_ASGMT,
                             EQUIPMENT     EQUIPMENT

                         WHERE
                            SITEA.site_id = PORT_ASGMT.site_id (+)
                And PORT_ASGMT.site_id = CUST_ACCESSA.site_id(+)
                            And PORT_ASGMT.equip_id = EQUIPMENT.equip_id (+)
                            And SITEZ.prem_loc_id = PREMISEZ.loc_id (+)
                            AND SITEA.prem_loc_id = PREMISEA.loc_id
                            And SITEZ.site_id = PVC.pvc_rsite_id (+)
                            AND SITEA.site_id = PVC.pvc_lsite_id
                            And PVC.pvc_id = IPFRA.pvc_id (+)
                            And PVC.pvc_id = IPFRZ.pvc_id (+)
                            And IPFRA.vpn_id = VPNA.vpn_id
                            And IPFRZ.vpn_id = VPNZ.vpn_id
                            And PVC.pvc_rcust_id = customerZ.cust_id
                            And PVC.pvc_lcust_id = customerA.cust_id
                            And CUST_ACCESSZ.cust_id = CUSTOMERZ.cust_id(+)
                            And CUST_ACCESSA.cust_id = CUSTOMERA.cust_id (+)
                            And upper(EQUIPMENT.equip_name) = 'BRHMAL01            '
                and PORT_ASGMT.port  = '39'
                and PORT_ASGMT.slot   = '3'  

 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close