FedSQL vs SQL

user24feb — Fri, 24 Apr 2015 07:16:00 GMT

Hello,

I'm playing around a little and it is obviously my first fedsql try.

If this program works:

Libname sqlserv ODBC Schema=DBO DSN=sassql;

Proc SQL NoPrint;
Create Table Test_A As
    Select Year_Month_Key, Sum(Sales_Group) As Sales_Group
    From sqlserv.vFact_Sales_Planning
    Where Year_Month_Key>=201401
    Group By Year_Month_Key
    Order By Year_Month_Key;
Quit;

why do I get the following error with fedsql:

Libname sqlserv ODBC Schema=DBO DSN=sassql;

Proc FedSQL NoPrint;
Create Table Test_A As
    Select Year_Month_Key, Sum(Sales_Group) As Sales_Group
    From sqlserv.vFact_Sales_Planning
    Where Year_Month_Key>=201401
    Group By Year_Month_Key
    Order By Year_Month_Key;
Quit;

Log:

ERROR: Table "SQLSERV.VFACT_SALES_PLANNING" does not exist or cannot be accessed

ERROR: ERROR: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name

'Planning_Datamart.DOMXXXXX\XXX.VFACT_SALES_PLANNING'.

Thanks&kind regards

Re: FedSQL vs SQL

SylviaPowell — Tue, 20 Oct 2015 18:46:00 GMT

PROC FEDSQL uses data source connection options from the LIBNAME statement; it does not use LIBNAME options. Try using the data source connection options documented in SAS/ACCESS to ODBC LIBNAME statement specifics: http://support.sas.com/documentation/cdl/en/acreldb/68028/HTML/default/viewer.htm#p0bu3zsz1a08ton1msxdx1jo45np.htm

topic FedSQL vs SQL in SAS Data Management

FedSQL vs SQL

Re: FedSQL vs SQL