BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
RafaelZ
Calcite | Level 5

Hi.


I'm using passthrough sql to fetch data from

sys_calendar.calendar in teradata.

and i get the error

ERROR: Librefs are restricted to eight characters. sys_calendar has been truncated.

How can i bypass this?


Thanks

Rafael




1                                                          The SAS System                                09:42 Tuesday, July 7, 2015

1          ;*';*";*/;quit;run;

2          OPTIONS PAGENO=MIN;

3          %LET _CLIENTTASKLABEL='Program5';

4          %LET _CLIENTPROJECTPATH='I:\מערכות מידע\SAS\Rafael\Main\Main222.egp';

5          %LET _CLIENTPROJECTNAME='Main222.egp';

6          %LET _SASPROGRAMFILE=;

7        

8          ODS _ALL_ CLOSE;

9          OPTIONS DEV=ACTIVEX;

10         GOPTIONS XPIXELS=0 YPIXELS=0;

11         FILENAME EGSR TEMP;

12         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR STYLE=HtmlBlue

12       ! STYLESHEET=(URL="file:///C:/SASHome/SASEnterpriseGuide/5.1/Styles/HtmlBlue.css") NOGTITLE NOGFOOTNOTE

12       ! GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on");

NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR

13       

14         GOPTIONS ACCESSIBLE;

15         proc sql;

16         connect to teradata as teracon (server=DWPROD  schema=DWP_VALL mode=teradata);

17       

18         (

19       

20         select *

21         from sys_calendar.calendar calendar

ERROR: Librefs are restricted to eight characters. sys_calendar has been truncated.

22         where calendar.calendar_date between date-100 and date

23       

24         order by calendar_date

           _____

           79

ERROR 79-322: Expecting a ).

25       

26       

27       

28         );

           _

           79

ERROR 79-322: Expecting a (.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

29       

30           disconnect from teracon;

NOTE: Statement not executed due to NOEXEC option.

31       

32           quit;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

      real time           3.33 seconds

      cpu time            0.01 seconds

    

33       

34       

35       

36         GOPTIONS NOACCESSIBLE;

37         %LET _CLIENTTASKLABEL=;

2                                                          The SAS System                                09:42 Tuesday, July 7, 2015

38         %LET _CLIENTPROJECTPATH=;

39         %LET _CLIENTPROJECTNAME=;

40         %LET _SASPROGRAMFILE=;

41       

42         ;*';*";*/;quit;run;

43         ODS _ALL_ CLOSE;

44       

45       

46         QUIT; RUN;

47       

1 ACCEPTED SOLUTION

Accepted Solutions
Patrick
Opal | Level 21

Wouldn't your code need to be something like:

select * from connection to teracon

     (

          select * from ......

     );

View solution in original post

2 REPLIES 2
Patrick
Opal | Level 21

Wouldn't your code need to be something like:

select * from connection to teracon

     (

          select * from ......

     );

RafaelZ
Calcite | Level 5

Hi Patrick

You are right Smiley Happy

I'm new to this..

Thanks

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 17048 views
  • 1 like
  • 2 in conversation