SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

FedSQL vs SQL

Reply
Super Contributor
Posts: 336

FedSQL vs SQL

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

SAS Employee
Posts: 5

Re: FedSQL vs SQL

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#p0bu3zsz1a08ton1ms...

Ask a Question
Discussion stats
  • 1 reply
  • 478 views
  • 0 likes
  • 2 in conversation