Hi Kevin,
I need some help writing a remote view in SQL that will allow the view to pull tables from multiple DBC's. I have posted this elsewhere in the thread, and have gotten no response. The view below generates a connectivity error, and is using one of the connections you helped me establish. Here is my previous post:
I was wondering if anyone out there knows how to code a SQL Select statement for a remote view that accesses tables on 2 different DBC's? I have created remote connections to each individual Client DBC in our project that work fine if the remote view only uses that DBC. The problem arises if I try to write a view like the one below which also calls the DBC common to all Clients in the project. Here is the view:
CREATE SQL VIEW "RV_MyView" REMOTE CONNECTION "RemoteConnectionToCompany1" AS SELECT ;
Orderdetails.*, ;
Paytypes.cpaytype, ;
Reason.cDesc ;
FROM 'Company1!OrderDetails' ;
LEFT OUTER JOIN common!paytypes ;
ON Orderdetails.ipaytype == Paytypes.ipaytype ;
LEFT OUTER JOIN common!Reason ;
ON Orderdetails.cReason == Reason.cReason ;
WHERE Orderdetails.uorder == ?vp_uorder
Thanks Kevin!
-Justin